SUMIF

[DME]

Is there a function similar to SUMIF that would take two criteria into
consideration? For instance

I want to sum all cells in Column C if Column A =3 and Column B =Yes.

I know sumif will work for 1 criteria but cannot seem to think of how to
make it sum for two.

thanks for the help.

[Jim May]

=SUMPRODUCT((A4:A12=3)*(B4:B12="Yes")*(C4:C12))

"DME" <craigjoseathotmaildotcom> wrote in message
news:eNb0ko$AFHA.3576@TK2MSFTNGP11.phx.gbl...
> Is there a function similar to SUMIF that would take two criteria into
> consideration? For instance
>
> I want to sum all cells in Column C if Column A =3 and Column B =Yes.
>
> I know sumif will work for 1 criteria but cannot seem to think of how to
> make it sum for two.
>
> thanks for the help.
>
>

[Trevor Shuttleworth]

Look at SUMPRODUCT

=SUMPRODUCT((A1:A50=3)*(B1:B50="yes")*(C1:C50))

Regards

Trevor


"DME" <craigjoseathotmaildotcom> wrote in message
news:eNb0ko$AFHA.3576@TK2MSFTNGP11.phx.gbl...
> Is there a function similar to SUMIF that would take two criteria into
> consideration? For instance
>
> I want to sum all cells in Column C if Column A =3 and Column B =Yes.
>
> I know sumif will work for 1 criteria but cannot seem to think of how to
> make it sum for two.
>
> thanks for the help.
>
>

[DME]

Thank You!



"Trevor Shuttleworth" <Trevor@Shucks.demon.co.uk> wrote in message
news:OdLUO0$AFHA.3836@tk2msftngp13.phx.gbl...
> Look at SUMPRODUCT
>
> =SUMPRODUCT((A1:A50=3)*(B1:B50="yes")*(C1:C50))
>
> Regards
>
> Trevor
>
>
> "DME" <craigjoseathotmaildotcom> wrote in message
> news:eNb0ko$AFHA.3576@TK2MSFTNGP11.phx.gbl...
> > Is there a function similar to SUMIF that would take two criteria into
> > consideration? For instance
> >
> > I want to sum all cells in Column C if Column A =3 and Column B =Yes.
> >
> > I know sumif will work for 1 criteria but cannot seem to think of how to
> > make it sum for two.
> >
> > thanks for the help.
> >
> >
>
>

[Trevor Shuttleworth]

You're welcome.


"DME" <craigjoseathotmaildotcom> wrote in message
news:eMpyUILBFHA.1408@TK2MSFTNGP10.phx.gbl...
> Thank You!
>
>
>
> "Trevor Shuttleworth" <Trevor@Shucks.demon.co.uk> wrote in message
> news:OdLUO0$AFHA.3836@tk2msftngp13.phx.gbl...
>> Look at SUMPRODUCT
>>
>> =SUMPRODUCT((A1:A50=3)*(B1:B50="yes")*(C1:C50))
>>
>> Regards
>>
>> Trevor
>>
>>
>> "DME" <craigjoseathotmaildotcom> wrote in message
>> news:eNb0ko$AFHA.3576@TK2MSFTNGP11.phx.gbl...
>> > Is there a function similar to SUMIF that would take two criteria into
>> > consideration? For instance
>> >
>> > I want to sum all cells in Column C if Column A =3 and Column B =Yes.
>> >
>> > I know sumif will work for 1 criteria but cannot seem to think of how
>> > to
>> > make it sum for two.
>> >
>> > thanks for the help.
>> >
>> >
>>
>>
>
>

[seve]

I have a similar problem, except I need to count column C if criteria
in Columns A and B are met.

Any ideas?

Thanks,

Steve

Trevor Shuttleworth wrote:
> You're welcome.
>
>
> "DME" <craigjoseathotmaildotcom> wrote in message
> news:eMpyUILBFHA.1408@TK2MSFTNGP10.phx.gbl...
> > Thank You!
> >
> >
> >
> > "Trevor Shuttleworth" <Trevor@Shucks.demon.co.uk> wrote in message
> > news:OdLUO0$AFHA.3836@tk2msftngp13.phx.gbl...
> >> Look at SUMPRODUCT
> >>
> >> =SUMPRODUCT((A1:A50=3)*(B1:B50="yes")*(C1:C50))
> >>
> >> Regards
> >>
> >> Trevor
> >>
> >>
> >> "DME" <craigjoseathotmaildotcom> wrote in message
> >> news:eNb0ko$AFHA.3576@TK2MSFTNGP11.phx.gbl...
> >> > Is there a function similar to SUMIF that would take two
criteria into
> >> > consideration? For instance
> >> >
> >> > I want to sum all cells in Column C if Column A =3 and Column B
=Yes.
> >> >
> >> > I know sumif will work for 1 criteria but cannot seem to think
of how
> >> > to
> >> > make it sum for two.
> >> >
> >> > thanks for the help.
> >> >
> >> >
> >>
> >>
> >
> >

[BenjieLop]

<< I have a similar problem, except I need to count column C if criteria
in Columns A and B are met.

Any ideas?

Thanks,

Steve >>


The formula presented above is basically the one that you need and you just have to modify it as follows:

=sumproduct((A1:A50="ColA condition")*(B1:B50="ColB condition")*(C1:C50))

so, just replace

"ColA condition" and "ColB condition" with your respective criteria for Column A and Column B.

Also, you might want to modify the range 1:50 to suit your needs.

Hope this helps.

[Trevor Shuttleworth]

Seve

one way:

=SUMPRODUCT((A2:A51=3)*(B2:B51="yes")*(C2:C51<>""))

Regards

Trevor


"seve" <scooksey@charter.net> wrote in message
news:1107072459.778252.189450@c13g2000cwb.googlegroups.com...
>I have a similar problem, except I need to count column C if criteria
> in Columns A and B are met.
>
> Any ideas?
>
> Thanks,
>
> Steve
>
> Trevor Shuttleworth wrote:
>> You're welcome.
>>
>>
>> "DME" <craigjoseathotmaildotcom> wrote in message
>> news:eMpyUILBFHA.1408@TK2MSFTNGP10.phx.gbl...
>> > Thank You!
>> >
>> >
>> >
>> > "Trevor Shuttleworth" <Trevor@Shucks.demon.co.uk> wrote in message
>> > news:OdLUO0$AFHA.3836@tk2msftngp13.phx.gbl...
>> >> Look at SUMPRODUCT
>> >>
>> >> =SUMPRODUCT((A1:A50=3)*(B1:B50="yes")*(C1:C50))
>> >>
>> >> Regards
>> >>
>> >> Trevor
>> >>
>> >>
>> >> "DME" <craigjoseathotmaildotcom> wrote in message
>> >> news:eNb0ko$AFHA.3576@TK2MSFTNGP11.phx.gbl...
>> >> > Is there a function similar to SUMIF that would take two
> criteria into
>> >> > consideration? For instance
>> >> >
>> >> > I want to sum all cells in Column C if Column A =3 and Column B
> =Yes.
>> >> >
>> >> > I know sumif will work for 1 criteria but cannot seem to think
> of how
>> >> > to
>> >> > make it sum for two.
>> >> >
>> >> > thanks for the help.
>> >> >
>> >> >
>> >>
>> >>
>> >
>> >
>