# Sumproduct Help

Hello
Sumproduct Help Needed:
Sumproduct in cell G2 is returning 99. But I want it to return 143
Reason  - Add up 77 not 33 to the  I column value of g1 – how can that be possible?

If there is a SGNumNew, then ignore the corresponding value of SGNum from the sumproduct sum and add the SGNumNew to the sumproduct
sumup2.xlsx
###### Who is Participating?

Commented:
Ok, try:

=SUMPRODUCT((INDEX(source,,1)=D2)*((INDEX(source,,6))+(INDEX(source,,7))))-SUMPRODUCT((INDEX(source,,1)=D2)*(ISNUMBER(INDEX(source,,7))*(INDEX(source,,6))))
0

Commented:
There are 3 g1's in column D, so should it be 99+77 = 176

with formula:

=SUMPRODUCT((INDEX(source,,1)=D2)*((INDEX(source,,6))+(INDEX(source,,7))))
0

Author Commented:
Hello NB_VC
Coditional Summ up – so if column J has a number : 0 or greater, then add it to the sum product and then subtract or remove the I value for the same row – its like overwrite – the column J value writes over the column I value  - makes sense? That’s why its should sum 143
0

Author Commented:
Thanks NB_VC
works like a charm
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.