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:


    =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!

Register Yourself Login