newbe help with formula

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
 

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

Top