Thanks guys,

They all worked great. Much appreciated.
Have a great year.

Steve

"Shane Devenshire" wrote:

Hi,

In 2003 if you want to exclude blank cells from the counts, enter these
three formulas on each sheet:

=SUMPRODUCT(--(A1:A12=-100),--(A1:A12<=100),--(A1:A12<""))
=SUMPRODUCT(--(A1:A12=-300),--(A1:A12<=300),--(A1:A12<""))-C11
=COUNT(A1:A12)-SUM(C11:C12)

In each case the range to look at is column A. In this example the first
formula is in C11, the second in C12.

In 2007
=COUNTIFS(A1:A12,"=-100",A1:A12,"<=100",A1:A12,"<")
=COUNTIFS(A1:A12,"=-399",A1:A12,"<=399",A1:A12,"<")-C11
and the third formula is unchanged from the 2003 version.

Formulas in the same locations as in the 2003 examples.

To sum these results to a summary page
=SUM(A:Z!C11)
=SUM(A:Z!C12)
=SUM(A:Z!C13)
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Steve" wrote:

If I have 26 tabs A:Z,
and in the P columns of each tab, there are various numbers such as:

0,-100, -400,-70, 100, 400, 70, etc.

I'd like to count how many a
between -100 and +100 &
bewteen -399 and + 399 ( not including the -100/+100 above) &
<-400 and 400.

Thanks,

Steve