sumif with multiple criteria

[Guest]

Hi,
I was wondering if there is a way to do a sumif with more
than one criteria.
like sum if country = canada and province = nova scotia

thank you

 

[Domenic]

Hi,
I was wondering if there is a way to do a sumif with more
than one criteria.
like sum if country = canada and province = nova scotia

thank you

Hi,

Assuming,

Column A = country
Column B = province
Column C = your values

try,

=SUMPRODUCT((A1:A100="Canada")*(B1:B100="Nova Scotia"),C1:C100)

Hope this helps!

 

[Juan Sanchez]

Try:

=SUMPRODUCT((A1:A18="Canada")*(B1:B18="Nova Scotia")*
(C1:C18))

Cheers
Juan