Hi all,
Struggling here with getting a formula to suit, hopefully someone can point me in the right direction.
I have a table that generates 2 charts from calculated values on each line. The problem I have is that I need to filter this data and have the formulated cells update based on only visible data. I have read many things online and watched a whole bunch of vids but can't find the solution myself.
So what I need is a formula for the running total $$ column and the running total units columns in the attachment. I need this to update as a cumulative sum of the filtered data.
If anyone can help me here it would be greatly appreciated. I can feel the grey hairs starting to sprout every time i try something!
Kind regards,
Jim
Bookmarks