Countif
Closed
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?
Related:
- Countif
- Countif in french - Guide
- How to count names in Excel: formula, using COUNTIF - Guide
1 response
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
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