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

    Assuming your numbers are in A1:A100 try either:




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

  • Re: Count Cells Between 0 And 365


Participate now!

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