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)

sumproduct forumla, but I want difference instead of sum
 

"Jeff Wheeler" wrote in message
...
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"?
--
David Biddulph

sumproduct forumla, but I want difference instead of sum
 

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

"Jeff Wheeler" wrote:

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)