That is just for display in dropdown, have no influence over subtotal
formulas so Pete's answer will still work


--

Regards,

Peo Sjoblom




gjcase" wrote in
message ...

A word of caution about counting items in the autofilter window: If
there are many items, sometimes the autofilter list is truncated, so a
count may be incorrect. I believe the limit is 1000 unique items.

---GJC


--
gjcase
------------------------------------------------------------------------
gjcase's Profile:
http://www.excelforum.com/member.php...o&userid=26061
View this thread: http://www.excelforum.com/showthread...hreadid=527060