Hello excel experts,
I am currently writing a macro that does a variety of things, one of these being that it automatically sums up columns I,J and K. The dilemma I have is that I need to be able to see the sum of the data in a cell at the bottom of the column, after manually filtering it according to what I want to see. Any help would be appreciated,
Best regards,
Bent
Last edited by bent_dietrich; 06-06-2014 at 07:24 AM.
Why not just use a Subtotal formula?
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Hi Olly,
Thank you for your quick reply. I am quite new to excel and macros, so I am not sure how to use a subtotal formula. If I have the data in column J and the data starts in row 7, how would I use this?
Thanks again,
Bent
Hello Olly,
Thanks you again, after doing a little googling I realzed that the subtotal formula was simple and exactly what I needed.
Thanks for your help!
@bent_dietrich
if your question in solved, will you mark it solved?
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks