Hi,

Am Tue, 19 Mar 2013 17:22:21 +0000 schrieb EmzOLV:

Now for the cells containing a value of less than 5, I've used the
following countif formula which works: =COUNTIF('RED WET
1'!P4:P185,"<=5.00")

For the cells containing a value of 100 or more, I've used the following
countif formula which works: =COUNTIF('RED WET 1'!P4:P185,"100.01")

Now, the inbetween values are where I am struggling.

For the cells containing a value which lies between 5.01 and 10, I have
this formula: =COUNTIF('RED WET 1'!P4:P185,"5.01")-COUNTIF('RED WET
1'!P4:P185,"<10.00")

try:
=COUNTIF(P4:P185,"<=10")-COUNTIF(P4:P185,"<=5")
or:
=SUMPRODUCT(--(P4:P1855),--(P4:P185<=10))


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2