Hi

You could also use this:

=SUMPRODUCT((A1:A173)*1,(A1:A17<6)*1)

Regards,
Per

skrev i meddelelsen
...
On Jul 3, 9:15 am, wrote:
This should be pretty easy; it's a little embarrasing to ask. I'm
trying to count all cells with a value within a specified range. It's
not working. Here is the formula I'm using:

=COUNTIF(A1:A17,(AND(A1:A173,A1:A17<6)))

Where am I going wrong?

That takes care of it. Thanks!