Help with formula

  • Thread starter Thread starter DR, Bob
  • Start date Start date
D

DR, Bob

I need a easy way to count the following cells with numbers less then 10.

columns c to h, rows 2 to 20, 30 to 40 & 50 to 60 in each column. The next 5
sheets I need to do the same thing but the rows are different on each sheet.

I was going to use
=(COUNTIF(c2:c20,"<10"))+(COUNTIF(c30:c40,"<10"))+(COUNTIF(c50:c60,"<10"))+.
... and so on until I have all the rows and columns covered but the formula
will get very long.

Is there a shorter formula I could use to save from using this very long
formula???

Thanks
 
You can check the columns in blocks as in:

=COUNTIF(C2:H20,"<10")+COUNTIF(C30:H40,"<10")+COUNTIF(C50:H60,"<10")

HTH

Sandy
 
Back
Top