Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations waross on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can I use 'Countif' to calculate results of IF statements??

Status
Not open for further replies.

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??
 
Replies continue below

Recommended for you

The line
=COUNTIF(C2:C4,"high")
works for me (the range C2:C4 being the cells in which the IF formula places "high", "medium" or "low").
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor