Quote Originally Posted by oldchippy
If you use this formula, it will count how many values in the ranges of column E are above zero, then you can take the total away from B48

=COUNTIF(E2:E10,">0")+COUNTIF(E13:E22,">0")+COUNTIF(E25:E31,">0")+COUNTIF(E34:E42,">0")
Awesome, thank you very much!