count only visible cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using an autofilter on a set of data. I would like to use a countif
field to summarize the visible cells only. So, every time I change the
autofilter I would change the criteria counted.

Any ideas out there?
 
Look at the subtotal function in help, it works on visible cells only

=SUBTOTAL(9,A2:A1000)

will sum A2:A1000 and when filtered it will sum only the visible cells in
A2:A1000

=SUBTOTAL(3,A2:A1000)

will count non empty visible cells


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com
 
Thanks,

Subtotal(3,) did the job.


Peo Sjoblom said:
Look at the subtotal function in help, it works on visible cells only

=SUBTOTAL(9,A2:A1000)

will sum A2:A1000 and when filtered it will sum only the visible cells in
A2:A1000

=SUBTOTAL(3,A2:A1000)

will count non empty visible cells


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

visible cell only 1
Count the number of AutoFiltered records 6
Excel Need Countifs Formula Help 0
Previous visible cell 2
COUNTIF___Visable only 4
Countif excluding hidden rows 4
How to keep Status count visible? 1
Count only visible formula results 2

Back
Top