Solved How do I show rolling totals

March 19, 2013 at 07:56:16
Specs: Windows XP
How would I show a rolling total in an excell sheet? for example: in may dr. saw 15 patients, then in June he saw 18, I would like to see the total to date patient load for that dr. of 33, not the 18. Then in July the total of the next month.

Thank you!

See More: How do I show rolling totals

Report •

March 19, 2013 at 09:07:20
✔ Best Answer
Without knowing how your data is arrainged,
the simplest is to just do a =SUM() on all
the previous months.

       A        B          C
 1)  Month   Patients  Total YTD
 2)  Jan       10      =SUM(B2:B13)
 3)  Feb        9
 4)  March     11
 5)  April      8           
12)  Nov       
13)  Dec       


Report •
Related Solutions

Ask Question