=SUMPRODUCT(--(A1:A100="Bob"),--(B1:B100="N"),C1:C100)

Note that SUMPRODUCT doesn't work with complete columns, you have to specify
a range.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Leslie M" <Leslie wrote in message
...
I am trying to add sales gross for individual salespeople, and break it
down
by new vehicles vs. used vehicles. I have a column set up for the sales
people, a column set up for the type (N or U), and a column set up for the
gross that I want to add. I can make it add up the gross of new vs. used
using the sumif function, but I don't know how to make it do "if this =
this,
and this = this, then add this through this". Does that make sense? I'm
sure
it's not as hard as I'm making it out to be. Can anyone help?

Thanks!