Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting values in multiple columns
How can I count the values in one column compared to the values in another
column. For instance if a column contains Critical, High, Med and Low and another column contains Mary, Joe and Steve, I would like to count the number of criticals where the other column contains Mary? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting values in multiple columns
try
=sumproduct((a2:a22="critical")*(b2:b22="Mary")) -- Don Guillett SalesAid Software "Emily" wrote in message ... How can I count the values in one column compared to the values in another column. For instance if a column contains Critical, High, Med and Low and another column contains Mary, Joe and Steve, I would like to count the number of criticals where the other column contains Mary? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting values in multiple columns
Hi, introduce a third column and filll its cells with a formula that looks like this: =IF(AND(A1="Mary",B1="Critical"),1,0) Replace the condition with what you are checking for. The cell will be set to 1 if the condition is fulfiled. By counting the number of 1's in the column, you can find the number of entries that meet the condition. -- C01d ------------------------------------------------------------------------ C01d's Profile: http://www.excelforum.com/member.php...o&userid=34422 View this thread: http://www.excelforum.com/showthread...hreadid=541932 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Count Rows with defined values in multiple columns | Excel Worksheet Functions | |||
Convert 1 row of data into Multiple columns | Excel Discussion (Misc queries) | |||
Counting Multiple Values In A Cell | Excel Worksheet Functions | |||
counting Multiple answers in 1 cell + column | Excel Discussion (Misc queries) | |||
Counting the Contents of Two Columns | Excel Discussion (Misc queries) |