On Jan 2, 9:46*am, 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

=SUMPRODUCT(--(ABS(P1:P100)<=100))
=SUMPRODUCT(--(ABS(P1:P100)<=400))-SUMPRODUCT(--(ABS(P1:P100)<=100))
=SUMPRODUCT(--(ABS(P1:P100)400))

Although this will count blank cells, too. Is that an issue? And I'm
not sure where you wanted the "equal to" counted, you weren't clear on
that.