How to calculate how many cells have a value of less than 3?

  • Thread starter Thread starter FISH
  • Start date Start date
F

FISH

What formula can you use to get the total number of entries from within a
range of cells that contain any value 3 or less?

I have a large numbers of results in a spreadsheet (results can be anywhere
from 1-10) and want to be able to easily get the total number of entries
that are either 1,2, or 3.

Thanks...
 
=countif(a1:b99,"<=3")

is one way.
What formula can you use to get the total number of entries from within a
range of cells that contain any value 3 or less?

I have a large numbers of results in a spreadsheet (results can be anywhere
from 1-10) and want to be able to easily get the total number of entries
that are either 1,2, or 3.

Thanks...
Click to expand...
 
Back
Top