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

the ranges cannot be whole columns

--

HTH

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


"Mosqui" <Mosqui@discussions.microsoft.com> wrote in message
news:ABF5F9A5-7C66-43D8-A1B5-243963261568@microsoft.com...
> 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.