Excel, Check cell and add assigned values

[Whatever]

Hi,

I have a spreadsheet with person names down the left and course names across the top. Each course has an allocated amount of time to it, say 4 hours but each course is different and this may change.

Each cell would be a 'yes' or 'no' and what I would like to do is add up the total hours that each employee has completed and display it in a cell. There are 14 courses at present.

Cheers.

Example Below:

[Tony]

Could do it something like the attached - use a separate sheet to pull the data and add it up.

[Whatever]

Cheers Tony,

Had thought along those lines to make it simpler but thanks for the example.

Paul