Thread: SUMIF using two columns in both Range and Criteria
View Single Post
  #3   Report Post  
Gordon
 
Posts: n/a
Default
Bob Phillips wrote:
=SUMPRODUCT(--(A1:A20&B1:B20="700012"),C1:C20)


I'd just found "sumproduct" but your version of it is MUCH neater. Thanks!
Reply With QuoteReply With Quote