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 (E-Mail Removed)> wrote in message
news:7679DD4A-3C60-4879-9AB4-(E-Mail Removed)...
> 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 (E-Mail Removed)> wrote in message
> news:7679DD4A-3C60-4879-9AB4-(E-Mail Removed)...
> > 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!! )

"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 (E-Mail Removed)> wrote in message
> news:7679DD4A-3C60-4879-9AB4-(E-Mail Removed)...
> > 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" <(E-Mail Removed)> wrote in message
news:70823A3F-E533-4A2E-BA2E-(E-Mail Removed)...
> I got it to work... thanks for your help!! )
>
> "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 (E-Mail Removed)> wrote in message
> > news:7679DD4A-3C60-4879-9AB4-(E-Mail Removed)...
> > > 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" <(E-Mail Removed)> wrote in message
> news:70823A3F-E533-4A2E-BA2E-(E-Mail Removed)...
> > I got it to work... thanks for your help!! )
> >
> > "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 (E-Mail Removed)> wrote in message
> > > news:7679DD4A-3C60-4879-9AB4-(E-Mail Removed)...
> > > > 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" <(E-Mail Removed)> wrote in message
> news:70823A3F-E533-4A2E-BA2E-(E-Mail Removed)...
> > I got it to work... thanks for your help!! )
> >
> > "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 (E-Mail Removed)> wrote in message
> > > news:7679DD4A-3C60-4879-9AB4-(E-Mail Removed)...
> > > > 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!
> > >
> > >
> > >
>
>
>