sumproduct forumla, but I want difference instead of sum

J

Jeff Wheeler

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)
 
D

David Biddulph

Jeff Wheeler said:
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)
Click to expand...

If there are, for example, 7 values in column C which meet your column A & B
criteria, what do you regard as "the difference"?
 
Top