Thread: sumproduct forumla, but I want difference instead of sum
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jeff Wheeler
 
Posts: n/a
Default sumproduct forumla, but I want difference instead of sum
I am using the formula below to get a value that meets certain criteria. I
now want column "c" to calculate the difference, intead of the sum. Is it
possible?

=SUMPRODUCT(--($A$2:$A$4000=35),--($B$2:$B$4000="PEGPACE"),$C$2:$C$4000)

Reply With QuoteReply With Quote