• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Running Total base on Column values

bluesky63

Member
Hi
Can some excel guru help in using simple method to achieve running total base on column values ( the three col is the desire result)

Thank you

FieldQTYRunning Total by Field Value
D001
2​
2​
D001
4​
6​
D001
89​
95​
D002
54​
54​
D002
4​
58​
T003
6​
6​
T003
11​
17​
T003
67​
84​
Z001
61​
61​
Z002
12​
12​
Z003
6​
6​
Z004
6​
6​
Z004
2​
8​
Z004
5​
13​
Z005
4​
4​
 

Attachments

  • RunningTotal.xlsx
    16.1 KB · Views: 4
Hi:

Find the attached. Formula in Green column.

Thanks
 

Attachments

  • RunningTotal.xlsx
    17.8 KB · Views: 5
Back
Top