SUMPRODUCT and SUMIF

[AlisaS]

Hello.

I am trying to create Sumproduct formula to calculate the total sum of deviations between OB and CC if deviation is >0 (I expect to receive 7). With this formula '=SUMPRODUCT(B17:F17-B18) I receive -23 that is sum of all deviations. How to create a formula, that would calculate only positive deviations without creating a separate row with deviations?


wk1 wk2 wk3 wk4 wk9
OB 6 15 30 24 27
CC 25 25 25 25 25
-19 -10 5 -1 2

CURRENT -23 =SUMPRODUCT(B17:F17-B18)
EXPECTED 7



Thank you in advance!

[XLent]

a sample file would have, but perhaps:

Please Login or Register  to view this content.

[AlisaS]

It works! Thank you very much!