Hi,

I have 3 columns Code(columnA), Subcode(columnB), Amount(columnC). I
have created a columnD (Sum per Code) in which i have to add the amount
with the previous amount in each cell till the subcode is same.

I have used the following formula:

=SUMPRODUCT((A3=A4)*(B3=B4),(C3+D2))

I am getting the data correct in all cells in column D except the cells
where subcode ends.

I have attachd an excel sheet and highlighten in yellow where I get
discrepancy. Can anyone help me?

Thanks in advance
Shankar


+-------------------------------------------------------------------+
|Filename: sample.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4247 |
+-------------------------------------------------------------------+

--
shankarexcel
------------------------------------------------------------------------
shankarexcel's Profile: http://www.excelforum.com/member.php...o&userid=30661
View this thread: http://www.excelforum.com/showthread...hreadid=503268