Count if multiple variable exist

S

Stan

I'm trying to count cells if muplite variable exist. For example, I want to
count if a range of cells is >0 or <500. I've tried COUNTIFS but I'm on
Excel 2003 and it doesn't like it. I guess it's for Office 2007. Can
someone tell me how to write a fuction either standard or nested that would
perform this count?

Many thanks if you can help!!
 
T

Teethless mama

COUNTIFS function is use for XL2007

=COUNTIF(A1:A100,">0")-COUNTIF(A1:A100,">=500")
or
=SUMPRODUCT(--(A1:A100>0),--(A1:A100<500))
 
Top