SUMIF function

[aedislee]

Good afternoon all

I want to use the above function SUM some totals based on criteria. However I have 2 sets of criteria too match for the sum too happen

Please advise how this can be done

Basically I want to say if cell A1 = 1 and cell B2 = 2 then SUM

Thanks in advance

[djfatboyfats]

There is probably a better way to do it but put this code in column C

Please Login or Register  to view this content.

This would return a 3 if 1 was present in A and 2 was present in B

[canapone]

Hi All,

a possible alternative solution

Please Login or Register  to view this content.

sumproduct can read also number in external closed files.

Regards

[aedislee]

Thanks for the replies

However, I think i am looking for something like this

If A1=1 then SUMIF(whatever), else 0

Thanks