sumproduct formula?

Hi there,

can someone help me with a formula please..

Requirements:

Sheet has 3 columns ((A)Depot, (B)Name, (C)Number of jobs)

Example

DA, Bob, 5
DA, Dave, 7
HU, Bob, 6
MA, Dave, 9

I need a formula which will work out how many jobs bob has done at DA.

Maybe i've overcomplicated the matter but hopefully someone can tell me.

Thanks

John

Try

=SUMPRODUCT(--(A1:A10="DA"),--(B1:B10="Bob"),C1:C10)

Just what I was looking for.

Thanks a lot.

John