Sorry, my bad. I corrected in my test but posted the old version. Should be

=IF(AND(A3=A2,B3=B2),D2+C3,C3)


--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"shankarexcel"
wrote in message
news:shankarexcel.21xnbb_1137759608.2481@excelforu m-nospam.com...

Hi Bob, thanks for your kind reply.

=IF(AND(A3=A2,B3=B2),D2+C3)
-- this formula won't work for the row 14 and 26 (gives "false" as
output) and this formula works if I update manually the top most column
D2.

Thanks
Shankar


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