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