Thread: How can i have all alike product codes in column A be matched with like cities in column B and then add the totals that are in column C
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
daddylonglegs[_50_] daddylonglegs[_50_] is offline
external usenet poster
  
Posts: 1
Default How can i have all alike product codes in column A be matched with like cities in column B and then add the totals that are in column C

Try this formula in D1 copied down

=IF((A1=A2)*(B1=B2),"",SUM(INDEX(C$1:C1,MATCH(1,IN DEX((A$1:A1=A1)*(B$1:B1=B1),0),0)):C1))


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=567246

Reply With QuoteReply With Quote