spreadsheet formula ??????

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

  1. 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.
  2. The following will work in Excel, not sure about StarOffice.

    =COUNTIF(d33:d100,"<31") - COUNTIF(d33:d100,"<=15")
  3. 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!!!!