EXCLUDE TOTAL FROM FILTER
Try this€¦
Use subtotal.
For example:-
=SUBTOTAL(9,B2:B4)
Change the Range B2:B4 to your desired cell range.
If this post helps, Click Yes!
--------------------
(Ms-Exl-Learner)
--------------------
"Dave" wrote:
Hi
I am trying to create a row which will only sum whatever is in a filtered
columns.
Can this be done??
|