Can I use 'Countif' to calculate results of IF statements??
Can I use 'Countif' to calculate results of IF statements??
(OP)
I have a number of cells that I've used an IF statement on to determine a certain result.
I've simply used IF text entries in a range of cells to determine if values are - "low", "medium", "high".
What I'd like to do is count the number of times any of these labels are used within a range of cells.
100 low
500 high
900 high
result: 2 (high)
When I use 'countif', I don't get a result.
Any suggestions please??
I've simply used IF text entries in a range of cells to determine if values are - "low", "medium", "high".
What I'd like to do is count the number of times any of these labels are used within a range of cells.
100 low
500 high
900 high
result: 2 (high)
When I use 'countif', I don't get a result.
Any suggestions please??
RE: Can I use 'Countif' to calculate results of IF statements??
=COUNTIF(C2:C4,"high")
works for me (the range C2:C4 being the cells in which the IF formula places "high", "medium" or "low").