Hi Jane,

See Debra Dalgleish's fikter functions pages at:

http://www.contextures.com/xlFunctions04.html


---
Regards,
Norman



"Jane" wrote in message
...
Afte auto-filtering specific categories, I then need to count values
<=1200,
<=3600, etc. I'm familiar with SUBTOTAL but basically need a SUBTOTALIF
type
of formula.

any help is appreciated

jane