Thread: If column = value sum another column and place result in cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
S Himmelrich S Himmelrich is offline
external usenet poster
  
Posts: 76
Default If column = value sum another column and place result in cell
I think this would be a simpler solution:

=SUMPRODUCT(--('SOURCE DATA'!D2:D4000="133957")+('SOURCE DATA'!
D2:D4000="146268"),'SOURCE DATA'!G2:G4000)

however I'm not getting my total of column G based on the two values
sepecified in range D2:D4000
Reply With QuoteReply With Quote