count & If fomula
Thanks Domenic.
The first formula works well. but the second one doesn't. I put
=SUMPRODUCT(--('Completed Cities'!G4:G400="IL"),--('Completed
Cities'!P4:P400"100%"))
but it doesn't work. It says #N/A. but values exist until raw 229. I put the
formula to raw 400 as I will add raws daily at bottom and I don't want to
change the formula each day. but If this is the case why the first formula
works well?
I put the first one as :
=SUMPRODUCT(--('Completed Cities'!G4:G400="IL"),--('Completed
Cities'!C4:C400="on"))
and another question, Is it possible that I put two condition as: How many
cities in state are "On" or "pending" status?
Really Thanks
BHR
"Domenic" wrote:
Try...
=SUMPRODUCT(--(StateRange=State),--(StatusRange=Status))
and
=SUMPRODUCT(--(StateRange=State),--(PercentageCompleteRange=PercentageCom
plete))
Hope this helps!
In article ,
Bahareh wrote:
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
|