Best way to produce and report on cumlative figures from a range of data

**reddwarf** · 08-02-2019, 09:06 AM

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

**Estevaoba** · 08-02-2019, 10:49 PM

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.

**reddwarf** · 08-05-2019, 05:14 AM

Excellent simple solution - thanks

Best way to produce and report on cumlative figures from a range of data

LinkBack

Thread Tools

Rate This Thread

Display

Best way to produce and report on cumlative figures from a range of data

Re: Best way to produce and report on cumlative figures from a range of data

Re: Best way to produce and report on cumlative figures from a range of data

Thread Information

Users Browsing this Thread

Similar Threads

Produce a report from a data file

[SOLVED] Extract specific data from a report and re-produce cleaner output

Excel 2007 : Compare two sheets of alpha numerical data and produce a report with the differences

Report - Summarising data/figures across multiple worksheets into one

Using Excel to produce a report

[SOLVED] Produce a report in specific layout from varying data

Cumlative figures - relate to TODAY()

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions