Cumulative running balance on multiple sources?

How to do a running (cumulative) balance per SOURCE (and without a Value error because of the heading)?
The data WILL be sorted over and over again.

Sample attached.

Anthony
CumulativeBalances.xlsx
LVL 9
Anthony MellorChartered AccountantAsked:
Who is Participating?
 
Rory ArchibaldConnect With a Mentor Commented:
=SUMIF(B$1:B2,B2,E$1:E2)

should work.
0
 
Anthony MellorChartered AccountantAuthor Commented:
So simple!

and fascinates me to see it in R1C1 formats because they don't change when copied:

some notes for me, this one replicates the A1 mixed abs/relative style
=SUMIF(R1C[-4]:RC[-4],RC[-4],R1C[-1]:RC[-1])

and this one is absolute
=SUMIF(R1C2:RC2,RC2,R1C5:RC5)
0
 
Anthony MellorChartered AccountantAuthor Commented:
I must learn this way of looking at things.
CumulativeBalancesSolved.xlsx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.