View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lisa Beach
 
Posts: n/a
Default Nested --- Subtotal IF function

How do I do this?

I'm using autofilter to hide rows that = 0.
to get the total I have
Subtotal (9, D2:D50)

Now I need to count if column A = A1
COUNTIF(A2:A50, A1)

The only problem w/ the above is that it counts the hidden rows. How do I
count only the visible rows?

Thanks in advance.

Lisa