software

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?

try
=sumproduct((a2:a22=quot;criticalquot;)*(b2:b22=quot;Maryquot;))

--
Don Guillett
SalesAid Software

quot;Emilyquot; gt; wrote in message
news
gt; How can I count the values in one column compared to the values in another
gt; column. For instance if a column contains Critical, High, Med and Low and
gt; another column contains Mary, Joe and Steve, I would like to count the
gt; number
gt; of criticals where the other column contains Mary?

Hi, introduce a third column and filll its cells with a formula that
looks like this:

=IF(AND(A1=quot;Maryquot;,B1=quot;Criticalquot;),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: www.excelforum.com/member.php...oamp;userid=34422
View this thread: www.excelforum.com/showthread...hreadid=541932