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!

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

When I type that formula in, it's coming up as $0.00 which isn't right. I'm
probably missing something- any ideas?

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

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!

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!

I had the salespeople identified by their sales numbers, not their names, and
therefore the quotes had to be removed around the number

"Bob Phillips" wrote:

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!