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")
|