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

the ranges cannot be whole columns

--

HTH

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


"Mosqui" wrote in message
...
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.