 # Count Cells Between Numeric Range

• I am trying to total the number of cells in a column that are 0 or greater but less than 365. I use countif for for a specific digit but cannot compute a conditional range using it. I need to count the number of positive digits btwn 0 and 365. The column is a computation of the difference btwn today and past and future dates. A plus digit means we missed sevice and better be ready for an angry customer. BTW the previous help I rcvd here on hidden sheets and data tables has allowed me to greatly improve my data presentations.

• Re: Count Cells Between 0 And 365

Can you use a DSUM formula?

• Re: Count Cells Between 0 And 365

Assuming your numbers are in A1:A100 try either:

=COUNTIF(A1:A100,">=0")-COUNTIF(A1:A100,">365")

or

=SUMPRODUCT((A1:A100>=0)*(A1:A100<=365))

I'm assuming you want to include 365 in the count

• Re: Count Cells Between 0 And 365

=SUMPRODUCT(--(A2:A9>0),--(A2:A9<365))
or
=COUNTIF(A2:A9,">0")-COUNTIF(A2:A9,">=365")
p45cal

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!