Thread: Sum product formula with conditions
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
TIMOTHY TIMOTHY is offline
external usenet poster
  
Posts: 45
Default Sum product formula with conditions
Thank you Alan & Rover

I have searched on google and found out the formula

=sumproduct(--(Range1,criteria1),--(Range2,criteria2),Range3,Range4)

In this case Range3 & 4 are column 2&3
Reply With QuoteReply With Quote