To sum based on the condition

[xlhelp15]

Hello All,

Kindly help me for the below query which I need in the way of Excel-VBA.

Here column A - is the serial number and I need to sum the values of Column C (56+44.01+33.20 = 133.21) and provide the value in Column D in row 1. Likewise, it needs to sum automatically for the Serial numbers - 2, 3, 4, 5 and so on.

Your help is greatly appreciated !
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]1234
[/TD]
[TD]56.00
[/TD]
[TD]133.21
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]44.01
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]33.20
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]4567
[/TD]
[TD]33.35
[/TD]
[TD]78.20
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]44.85
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Joe4]

If you use the method here to fill in the blank cells in column A with the value from above, then you can easily use the SUMIF function to get your totals:
https://www.extendoffice.com/documents/excel/771-excel-fill-blank-cells-with-value-above.html

After you do that, if your data was in cells A2:C6, you could enter this formula in D2 and copy down to D6:

=IF(A2<>A1,SUMIF(A$2:A$6,A2,C$2:C$6),"")

 

[xlhelp15]

Thanks much for your kind assistance, Joe.