Count

F

Flipside

Hi,

Need some help on COUNT.

Need to count all values which are between 0 & 2 (this is on another
sheet within my spreadsheet called "Data")


Any help would be sweet.

Thanks
 
B

Bob Phillips

=COUNTIF(Data!A1:A100>=0)-COUNTIF(Data!A1:A100>2)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
F

Flipside

Thanks for your reply but it says that there are too few arguements....
Any ideas?
 
B

Bob Phillips

Sorry, wrong syntax

=COUNTIF(Data!A1:A100,">=0")-COUNTIF(Data!A1:A100,">2")

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Top