Can you tell us what the problem was just in case someone else gets it?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Leslie M" wrote in message
...
I got it to work... thanks for your help!! :o)

"Bob Phillips" wrote:

=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!