G
Guest
I want to sum a corresponding number in column C if the cell in column D is
between + -50.
between + -50.
F
Frank Kabel
Hi
one
way:
=SUMIF(D
,">-50",C:C)-SUMIF(D,">=50",C:C)
or try
=SUMRODUCT(--(D1100>-50),--(D1100<50),C1:C100)
one
way:
=SUMIF(D
,">-50",C:C)-SUMIF(D,">=50",C:C)or try
=SUMRODUCT(--(D1
100>-50),--(D1100<50),C1:C100)
A
Aladin Akyurek
=SUMIF(D,">="&E2,C:C)-SUMIF(D,">"&F2,C:C)
where E2 houses -50 and F2 +50.
,">="&E2,C:C)-SUMIF(D,">"&F2,C:C)where E2 houses -50 and F2 +50.
H
Harlan Grove
Frank Kabel said:or try
=SUMRODUCT(--(D1
More compact,
=SUMPRODUCT(--(ABS(D1
100)<50),C1:C100)