Horizontal Running Total with Table References

HOW TO ATTACH YOUR SAMPLE WORKBOOK:

Fast answers need clear examples. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. For a new thread (1st post), scroll to Manage Attachments, otherwise scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.

Try:

Formula:

Please Login or Register  to view this content.

dragged across.

This worked!! Thank you so much for your help!

Edit: I may have spoken too soon. Doesn't appear to be working. Any additional help would be greatly appreciated.

Edit 2: I took a closer look and it is working Sorry for the confusion!

Doesn't appear to be working.

Is not very helpful. In what way doesn't it appear to be working? Works for me. How not so for you?

If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

You're welcome. Thanks for the rep.