Home |
Search |
Today's Posts |
#1
|
|||
|
|||
countif help for multiple criterias
I am try to set a formula to get a count based on two cells. Basically the formula should read If column A = "Apples" and column D = "Oranges" then count it. When I nest the formulas, it does not consirer both conditions. As long as one condition matches, it counts it. Any help would be much appreciated. -- tdro ------------------------------------------------------------------------ tdro's Profile: http://www.msusenet.com/member.php?userid=2199 View this thread: http://www.msusenet.com/t-1870535240 |
#2
|
|||
|
|||
Try this:
=SUMPRODUCT((A1:A100="Apples")*(D1:D100="Oranges") ) -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "tdro" wrote in message ... I am try to set a formula to get a count based on two cells. Basically the formula should read If column A = "Apples" and column D = "Oranges" then count it. When I nest the formulas, it does not consirer both conditions. As long as one condition matches, it counts it. Any help would be much appreciated. -- tdro ------------------------------------------------------------------------ tdro's Profile: http://www.msusenet.com/member.php?userid=2199 View this thread: http://www.msusenet.com/t-1870535240 |
#3
|
|||
|
|||
Is this what you want? If not, give an example =SUMPRODUCT((A1:A10="Apples")*(D1:D10="Oranges")) Sums (A1="Apples)*(D1="Oranges)+(A2="Apples)*(D2="Orang es)+... ...which in this case is equal to Count. HTH Ola Sandström -- olasa ------------------------------------------------------------------------ olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760 View this thread: http://www.excelforum.com/showthread...hreadid=379031 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF COMBINATION?? | Excel Worksheet Functions | |||
Combining IF and COUNTIF based on two columns | Excel Discussion (Misc queries) | |||
COUNTIF in one colum then COUNTIF in another...??? | Excel Worksheet Functions | |||
Countif - Countif | Excel Worksheet Functions | |||
countif, again | Excel Worksheet Functions |