count & If fomula
Hello
There is a rutine counting each week (very boring) I want to make it
authomatic. I have an spread sheet which 4 columns are important:
city, city status (On/Semi), state, %complete
I want this counting perocess:
1- I want to count: How many cities in each state are in "On" status?
2-I want to count: How many cities in each state are "100%" complete?
Please Help me to get ride of this boring manual updating.
Thanks
BHR
|