Doesn't the sumproduct function ADD the values, not count them?
--
Barb


"Bondi" wrote:


Barb Miles wrote:
I have a range of numbers between 1 and 25 in 50 cells.

How could I use the countif function to look at that range of numbers for
values between 5 and 10 and count those values that meet the criteria of
between 5 and 10?

Or if there is another function to use, let me know.

Thank you.
--
Barb

Hi Barb,

Maybe you can use the Sumproduct()

Something along the lines of:

=SUMPRODUCT(--(A1:A505),--(A1:A50<10))

Regards,
Bondi