See attached scaled-down anonymised version of the actual workbook. I record monthly spend figures from different business areas and once completed I am required to report the cumulative spend to date (A100:S124 shows what I am reporting for this month).
I have tried automating this process via a Pivot Table but I can't seem to fit all the columns (19) on the Pivot Table - it's possible I am not doing this right - can someone help?
Thanks
Last edited by reddwarf; 08-02-2019 at 10:24 AM.
I assume you need formulas in columns U and V, so try this:
Formula:
Please Login or Register to view this content.
Copy to V101, then copy down.
Excellent simple solution - thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks