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") |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
better way to write a count if statement?
You are adding up the ones that are either greater than or less than
zero, so how about =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") HTH, JP On Mar 27, 1:56*pm, luscioussarita wrote: 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") |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
better way to write a count if statement?
JP thank you it worked perfectly!!!
Have a nice day!!! Sarita "JP" wrote: You are adding up the ones that are either greater than or less than zero, so how about =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") HTH, JP On Mar 27, 1:56 pm, luscioussarita wrote: 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") |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
better way to write a count if statement?
Glad to hear it!
Enjoy, JP On Mar 27, 4:30*pm, luscioussarita wrote: JP thank you it worked perfectly!!! Have a nice day!!! Sarita "JP" wrote: You are adding up the ones that are either greater than or less than zero, so how about =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") |
Reply |
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 |