| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fomula (if?) | Excel Worksheet Functions | |||
| Fomula | Excel Discussion (Misc queries) | |||
| Please help, i need a fomula | Excel Worksheet Functions | |||
| IF Fomula | Excel Discussion (Misc queries) | |||
| To get fomula to display a Zero | Excel Discussion (Misc queries) | |||
Hybrid Mode
