Thread
:
How can I show the total sum of items in a filtered column
View Single Post
#
2
Roger Govier
Posts: n/a
=SUBTOTAL(9,A1:A100) will total just the visible cells.
Change range to suit.
I always put my formulae in a row above the headings.
--
Regards
Roger Govier
"huckie" wrote in message
...
Reply With Quote