SUMPRODUCT issue - need to count based on 3 text columns

Hi all - any help greatly appreciated with this please!
I have a spreadsheet tracking people's progress with tasks. I want it to calculate for each person how many tasks they've completed on time, and how many they've been late on. There are 3 columns I need to pick data up from for this.

Column C - name of task - for example "Call for Reports"
Column D - person responsible - indicated by their initials - for example "HB"
Column G - completed on time - indicated by "yes" or "no"

So for example, I want to calculate how many times "HB" has completed the "Call for Reports" on time. So I need it to pick up all cases where "Call for reports" from column C have been assigned "HB" from column D, and she's achieved a "Yes" from column G.
All 3 columns are text based then. I've tried to use SUMPRODUCT to do it - but I can only get it to calculate the first 2 columns and not the 3rd!

Any ideas please!? Is it actually possible?

Thanks in advance!

Try something like this:

=SUMPRODUCT((C2:C100="Call for Reports")*(D2:D100="HB")*(G2:G100="yes"))

You could also use COUNTIFS for this.

Adjust the ranges to suit your data.

Hope this helps.

Pete

That's done it!
Brilliant - thanks so much.

That should also earn me some massive brownie points in the office :-)

Do yourself a favour (unless you need backward compatibility) and go with COUNTIFS() (as Pete_UK mentioned) because it is more efficient.

=COUNTIFS(C2:C100,"Call for Reports",D2:D100,"HB",G2:G100,"yes")

Lovely - they both work perfectly.
Thanks again guys.