excel, how do I get sumif with two criterias?

M

Mosqui

I've got a table with many columns and I want to add the last left column but
using two criterias for two different columns.
 
B

Bob Phillips

=SUMPRODUCT(--(rng1="criteria1"),--(rng2="criteria2"),rng3)

the ranges cannot be whole columns

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top