sumproduct forumla, but I want difference instead of sum

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

 

[David Biddulph]

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)

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

 

[Barb Reinhardt]

I'm not sure I understand the question. What do you want the difference of?