EXCLUDE TOTAL FROM FILTER
Hi
The only problem is when I filter the column, the row with the subtotal in
dissparears. How do i keep the row in the filter?
Thanks
"Mike H" wrote:
Hi,
Do you mean visible cells in a filtered column. If so use SUBTOTAL
=SUBTOTAL(109,B2:B8)
109 makes to sum only visible rows.
Mike
"Dave" wrote:
Hi
I am trying to create a row which will only sum whatever is in a filtered
columns.
Can this be done??
|