A alanack Nov 22, 2002 #1 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.
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.
M Mr Subliminal Nov 22, 2002 #2 The following will work in Excel, not sure about StarOffice. =COUNTIF(d33:d100,"<31") - COUNTIF(d33:d100,"<=15")
The following will work in Excel, not sure about StarOffice. =COUNTIF(d33:d100,"<31") - COUNTIF(d33:d100,"<=15")
A alanack Nov 22, 2002 #3 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!!!!
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!!!!
