I want to sum a corresponding number in column C if the cell in column D is
between + -50.
I want to sum a corresponding number in column C if the cell in column D is
between + -50.
=SUMIF(D:D,">="&E2,C:C)-SUMIF(D:D,">"&F2,C:C)
where E2 houses -50 and F2 +50.
sam158963 wrote:
> I want to sum a corresponding number in column C if the cell in column D is
> between + -50.
>
>
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" <[email protected]> schrieb im Newsbeitrag
news:[email protected]...
>I want to sum a corresponding number in column C if the cell in column D is
> between + -50.
>
>
or...
=SUM((C2:C20)*(ABS(D2:D20)<50))
Confirm the Formula by pressing Ctrl+Shift+Enter not just Enter.
Regards,
Ola
"Frank Kabel" <[email protected]> wrote...
....
>or try
>=SUMRODUCT(--(D1:D100>-50),--(D1:D100<50),C1:C100)
More compact,
=SUMPRODUCT(--(ABS(D1:D100)<50),C1:C100)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks