View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
 
Posts: n/a
Default How can I count a column with any value in it?

=SUBTOTAL(3,Your_Range)

Regards,

Peo Sjoblom


"Felix" wrote in message
oups.com...
I have a list of students with email, names etc
I have the data filter function on so I can look at it like a DB, but
when I filter lets say on an organization to find out how many people
are in that org, I have to count manually. Is there a way to add a
count items function to give me an instant count?
Thanks
Felix