sumif with multiple criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
Click to expand...

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!
 
Try:

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

Cheers
Juan
 
Back
Top