How do I make it add a column based on 2 different criteria?
 

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!

How do I make it add a column based on 2 different criteria?
 

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

How do I make it add a column based on 2 different criteria?
 

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!

How do I make it add a column based on 2 different criteria?
 

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!

How do I make it add a column based on 2 different criteria?
 

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!

How do I make it add a column based on 2 different criteria?
 

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!