SUMIF
 

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.

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

"DME" <craigjoseathotmaildotcom wrote in message
...
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.

Look at SUMPRODUCT

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

Regards

Trevor


"DME" <craigjoseathotmaildotcom wrote in message
...
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.

Thank You!



"Trevor Shuttleworth" wrote in message
...
Look at SUMPRODUCT

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

Regards

Trevor


"DME" <craigjoseathotmaildotcom wrote in message
...
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.

You're welcome.


"DME" <craigjoseathotmaildotcom wrote in message
...
Thank You!



"Trevor Shuttleworth" wrote in message
...
Look at SUMPRODUCT

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

Regards

Trevor


"DME" <craigjoseathotmaildotcom wrote in message
...
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.

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
...
Thank You!



"Trevor Shuttleworth" wrote in message
...
Look at SUMPRODUCT

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

Regards

Trevor


"DME" <craigjoseathotmaildotcom wrote in message
...
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

one way:

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

Regards

Trevor


"seve" wrote in message
oups.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
...
Thank You!



"Trevor Shuttleworth" wrote in message
...
Look at SUMPRODUCT

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

Regards

Trevor


"DME" <craigjoseathotmaildotcom wrote in message
...
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.