View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Spiky Spiky is offline
external usenet poster
 
Posts: 622
Default Help, I need a formula for work.

What about:
SUBTOTAL(3,range)

Not sure why this simple version wouldn't work, if Autofilter is being
used.