Hi

I have a workbook with the following worksheets.

I am using the formula =SUMIF('Training'!A:A,A1,'Training'!B:B) to add
up individuals totals but I have now included another column C which
has 'yes' & 'no' response. How can I adapt the formula to only add up
the 'no' totals?

Thanks
Debbie

Example
Personal Worksheet
A B
1 Bob
2 Gail
3 Fred
4 Gae
5 Gary
Training Worksheet
A B C
1 Bob 4 Yes
2 Gail 6 No
3 Gail 1 Yes
4 Gae 5 No
5 Bob 7 Yes
6 Bob 8 Yes
7 Fred 9 No
8 Fred 5 Yes

=SUMIF('Training'!A:A,A1,'Training'!B:B)