count & If fomula
Great! thanks!
"Domenic" wrote:
In article ,
Bahareh wrote:
Thanks Domenic
You're very welcome!
...but still I don`t know how to put 100% for second question
Remove the quotes...
=SUMPRODUCT(--('Completed Cities'!G4:G400="IL"),--('Completed
Cities'!P4:P400100%))
...and If it is possible for 1st question to add another condition as:
How many cities in each state are "on" or "pending" status
=SUMPRODUCT(--('Completed
Cities'!G4:G400="IL"),--ISNUMBER(MATCH('Completed
Cities'!C4:C400,{"on","pending"},0)))
Hope this helps!
|