Running Total from Unique Ref

[Nickpop]

Hey Dudes and Dollies

Was wondering if any kind soul can try and work this one our for me?

From the list below I am trying to show a running total of Payment Values based on the first Ref column.

For example, i want Excel to be able to identify all the cases of F21.001 in column A, and then return in Column C the total of all the payment values in Column D.

But here is the fun bit... i want the running total to show up in the current total running figure in every line that it appears. Then as i add in another line of F21.001, it will be able to read the unique ref (F21.001) and then add the latest payment value i key in to ALL of the running total lines for F21.001

So for example, if i key in on my next line
Column A = F21.001
Column D = £18

Then... Columnc C will update all rows of F21.001 to reflect £2100

Thanks !
Nick

 

[aaewalsh]

Try This

=SUMIF(A:A, A2, D:D)

Paste the formula in in C2

 

[aaewalsh]

Running Total from Unique Ref.xlsx
	A	B	C	D
1	Ref	Date	Running Total	Payment Value
2	F21.001	01/01/2023	€ 2,082.00	€ 32.00
3	F21.002	02/01/2023	€ 1,074.00	€ 98.00
4	F21.002	03/01/2023	€ 1,074.00	€ 56.00
5	F21.003	04/01/2023	€ 150.00	€ 98.00
6	F21.002	05/01/2023	€ 1,074.00	€ 464.00
7	F21.001	06/01/2023	€ 2,082.00	€ 985.00
8	F21.002	07/01/2023	€ 1,074.00	€ 456.00
9	F21.003	08/01/2023	€ 150.00	€ 4.00
10	F21.003	09/01/2023	€ 150.00	€ 48.00
11	F21.001	10/01/2023	€ 2,082.00	€ 56.00
12	F21.004	11/01/2023	€ 152.00	€ 65.00
13	F21.004	12/01/2023	€ 152.00	€ 87.00
14	F21.001	13/01/2023	€ 2,082.00	€ 989.00
15	F21.005	14/01/2023	€ 89.00	€ 89.00
16	F21.001	15/01/2023	€ 2,082.00	€ 5.00
17	F21.001	16/01/2023	€ 2,082.00	€ 15.00
Sheet1

Cell Formulas
Range	Formula
C2:C17	C2	=SUMIF(A:A, A2, D:D)

 

[Nickpop]

Try This

=SUMIF(A:A, A2, D:D)

Paste the formula in in C2

Ooooooooohhhh Crafty!!!!!!!! thank you sir!

 

[shinigamilight]

C2: =IF(A2=$A$2,SUMIFS($D$2:$D$17,$A$2:$A$17,A2),"")