Previous Topic Next Topic

Countif

Closed
jack - Mar 15, 2009 at 03:59 PM
 ditzysuz - Mar 15, 2009 at 05:45 PM
Hello, I am adding a column to my excel sheet and would like to do an if statement. This is the statement I am trying to put into a formula . Identify which cities have had expenditure growth exceeding 3 percent on an annual basis. Identify these cities with a 1 and identify those with less than or equal to 3% with a 0. Can anyone help?

1 response

Answer 1 / 1
ditzysuz
Mar 15, 2009 at 05:45 PM
Hi Jack

Assuming this is what you are after

A B C
CityX 3.1% =if(B<=3%, 0, 1) "will return value 1"
CityY 3.0% =if(B<=3%, 0, 1) "will return value 0"
CityZ 2.9% =if(B<=3%, 0, 1) "will return value 0"

You can then count the number of cities have values 1 by using the formula =countif(C2:C4, 1) and number of cities have values 0 with =countif(C2:C4,0).

Hope it helps.
DitzySuz
0

Similar discussions

Counting cells containing only numbers
jutulu -
jutulu -

4 responses
Excel Golf Skins Sheet
agw2010 -
agw2010 -

2 responses
Cell format - COUNTIF then subtract from another cell
kieferschild -
ac3mark -

5 responses
Can the formula COUNTA / COUNT exclude 0 values?
doublewitt -
doublewitt -

2 responses
,">"&0),"") at the end of a countif formula
jutulu -
toony -

4 responses