Re: Sum column if multiple criteria are met in adjacent cells

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

This would work just as well:

=SUMPRODUCT((A1:A10="03")*(B1:B10="S")*C1:C10)

But to explain the unary, check these out:

http://www.mcgimpsey.com/excel/formulae/doubleneg.html

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"GateKeeper" <GateKeeper@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B73ECCA3-7E3D-4F99-812A-50A18C61DEDE@xxxxxxxxxxxxxxxx
> Perfect. What is the purpose of the "--"?
> --
> GateKeeper
> Experienced Computer User
>
>
> "David Billigmeier" wrote:
>
> > Assume your values are in the range A1:A10, B1:B10 and C1:C10:
> >
> > =SUMPRODUCT(--(A1:A10="03"),--(B1:B10="S"),C1:C10)
> > --
> > Regards,
> > Dave
> >
> >
> > "GateKeeper" wrote:
> >
> > > I have a table like this:
> > >
> > > Column_A Column_B Column_C
> > > 03 S 100
> > > 03 T 100
> > > 02 S 100
> > > 02 T 100
> > > 04 S 100
> > > 04 T 100
> > >
> > > I want to sum the cells in C only when A="03" and B="S". In this
case, I
> > > would expect the total to be 100.

.

Relevant Pages