Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF Help
Hello, I am trying to get a formula correct that basically performs the following function: =COUNT(IF(Data!$C$2:$C$191=Summary!B$3,IF(Data!$M$ 2:$M$191,"X",0)))... But I want it to return the count of the "X"s in that column (right now it omits the "X"s and counts the other cells. Also, if I wanted to use this same formula and have it count the number of "1"s, "2"s, or "3"s in a column, how would I do that? Any help is appreciated! Thank you! -- raspywench ------------------------------------------------------------------------ raspywench's Profile: http://www.excelforum.com/member.php...o&userid=20717 View this thread: http://www.excelforum.com/showthread...hreadid=496437 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF Help
not sure I understand what you want to do but =sumproduct((Data!$C$2:$C$191=Summary!B$3)*(Data!$ M$ 2:$M$191="X")) i think will do it - count x's in column M subject to meeting critiera for column C -- duane ------------------------------------------------------------------------ duane's Profile: http://www.excelforum.com/member.php...o&userid=11624 View this thread: http://www.excelforum.com/showthread...hreadid=496437 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula format for Count or Countif funtion with two criterias | Excel Worksheet Functions | |||
COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
Combining IF and COUNTIF based on two columns | Excel Discussion (Misc queries) | |||
Countif - Countif | Excel Worksheet Functions | |||
countif, again | Excel Worksheet Functions |