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?