Auto Filter - Add visible cells

D

Doobrifurkin

Hi,
I have a list containing numerical and text values. I have applied an auto
filter and would like to place a formula that adds up these values of the
visible cells only. I have used SUBTOTAL(3,A7:A117) for example, but this
adds up all the cells, not this filtered visible ones as I would like.
Can you help?
Thanks
Wayne
 
D

Doobrifurkin

Thanks Mike, but this didn't work. It showed a value of '0' when filtered or
not. I have no blank cells etc. Can I try anything else?

Thanks
 
D

Doobrifurkin

Thanks again Mike.
I have managed to solve the mystery. I had unused rows between the formula
and the filtered lists. Thanks
 

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

Cumulative formula for word table 0
visible cell only 1
How do I VLookup visible cells only? 2
Function for visible cells only 1
VB Script reference cells for in current table? 1
Subtotal Formula 1
Copy only visible cells after filter is applied/ sum after filter 0
histogram dynamic bin count 0

Top