Hi
one
way:
=SUMIF(D:D,"-50",C:C)-SUMIF(D:D,"=50",C:C)
or try
=SUMRODUCT(--(D1:D100-50),--(D1:D100<50),C1:C100)
--
Regards
Frank Kabel
Frankfurt, Germany
"sam158963" schrieb im Newsbeitrag
...
I want to sum a corresponding number in column C if the cell in column D is
between + -50.
|