50gumbys
Computer
- Feb 4, 2003
- 7
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??