Thread: How can I count items in a filtered list?
View Single Post
  #38   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] sabreindustriesga@gmail.com is offline
external usenet poster
  
Posts: 5
Default How can I count items in a filtered list?
On Thursday, July 21, 2005 at 1:09:14 PM UTC-4, filtered Counting filtered data. wrote:
I have an excel spread sheet table that I filter. I would like to be able to
count the number of cells in the filtered data. Anyone know how to do this?
This does not Work
I need to count the number for each month (filtered)
Please help

=MONTH(SUBTOTAL(3,AL12:AL10000)=5)
Reply With QuoteReply With Quote