View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
shankarexcel
 
Posts: n/a
Default Sum with multiple conditions


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