Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
=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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
#5
|
|||
|
|||
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. |
#6
|
|||
|
|||
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. |
#7
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions | |||
help with "criterea" in the sumif function | Excel Worksheet Functions | |||
SUMIF between dates | Excel Worksheet Functions | |||
SUM(IF( Array to avoid #NUM! values | Excel Worksheet Functions |