cumulitive totals and FILTER

[Laura]

I posted the following questions and rec'd the following reply for help on
getting my cumulitive column to total correctly when I sort.

However, the solution does not work when I apply a filter to columns. Is
there code that would apply to both situations?

Thanks
___________________________________

You could try something like this in F2:

=IF(ISNUMBER(F1),E2+F1,E2)

and copy this down, assuming that you have headers in row 1. When the
data is sorted, whatever is in row 2 will just take the value of E2 as
the starting point for the cumulative total, whereas every other row
will add the value in E onto the running total.

Hope this helps.

Pete

 

[Mike H]

To sum the visible data on a filtered column try:-

=SUBTOTAL(9, A2:OFFSET(A183,-1,0))

Paste into a cell below your last line of un-filtered data and alter the A2
- A183 to suit.

Mike