| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
better way to write a count if statement?
Hi Everyone,
Is there any better way to write this count if statement? I need it to look up four different columns and count if they contain any money. Is there a shorter way to write this or am I stuck? =COUNTIF('CALICO Unmapped Not Active'!T6:T42,"0") +COUNTIF('CALICO Unmapped Not Active'!W6:W42,"0") +COUNTIF('CALICO Unmapped Not Active'!AL6:AL42,"0") +COUNTIF('CALICO Unmapped Not Active'!AO6:AO42,"0") +COUNTIF('CALICO Unmapped Not Active'!T6:T42,"<0") +COUNTIF('CALICO Unmapped Not Active'!W6:W42,"<0") +COUNTIF('CALICO Unmapped Not Active'!AL6:AL42,"<0") +COUNTIF('CALICO Unmapped Not Active'!AO6:AO42,"<0") |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I write a compound if statement? | Excel Worksheet Functions | |||
| how do I write an IF/other statement to cut off time data? | Excel Worksheet Functions | |||
| How do you write an if statement that replaces #DIV/0! with 0 | Excel Discussion (Misc queries) | |||
| how do I write the date in an if statement | Excel Worksheet Functions | |||
| How do I write a conditional statement in Excel to count if two c. | Excel Worksheet Functions | |||
Threaded Mode
