Hi
Try this sumproduct formula:

=Sumproduct(--(A1:A100="London"),--(B1:B100=4),C1:C100)

Regards,
Per

"Mark D" skrev i meddelelsen
...
Good afternoon all, I am looking for some help if possible

I need excel to take a sum based on 2 sets of critiera

I put cells in just for reference

For example

Office Band Amount
A1: London B1: 4 C1: 2000
A2: Geneva B2: 3 C2: 3000
A3: Stuttgart B3: 2 C3: 4000

So I am trying to do the following

=IF(A1="London" AND, B1=4,c1)

I know the calculation above isnt right but I am trying like mad to work
it
out and am stuck.

Any help greatly appreciated.