spreadsheet formula ??????

Discussion in 'Trading Software' started by alanack, Nov 22, 2002.

  1. alanack

    alanack

    I'm trying to count the cells in a column in which the value falls within a given range.

    I tried: =count(15<d33:d100<31)

    Also tried: =count(if(15<d33:d100<31))

    I'm using StarOffice. Thanks.
     
    #1     Nov 22, 2002
    Share
  2. Mr Subliminal

    Mr Subliminal

    The following will work in Excel, not sure about StarOffice.

    =COUNTIF(d33:d100,"<31") - COUNTIF(d33:d100,"<=15")
     
    #2     Nov 22, 2002
    Share
  3. alanack

    alanack

    I got it. I had to start out by counting all the values in the column, then subtracting the higher and lower ranges. Couldn't have done it without you. THANKS!!!!
     
    #3     Nov 22, 2002
    Share