better way to write a count if statement?

  • Thread starter Thread starter luscioussarita
  • Start date Start date
L

luscioussarita

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting independent items in a list 3
Excel 2007 Formula and VBA help 5
Count If Conditions Are Trus 6
count if equal to not working? 1
Long If Statement 3
Limited to 7 IF Statements 2
UDF ...VBA Formula built ...please help 22
If+if+if+if... Does anyone know a better way? 2

Back
Top