Counting values in multiple columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
Back
Top