=SUMPRODUCT(SUMIFS....Formula Ammendment

Hi,

I have the following formula in S5 on the takeoff tab:

=SUMPRODUCT(SUMIFS(Data!G:G,Data!A:A,$G$4:$O$4,Data!G:G,"<0"),$G5:$O5)

It is adding up the any power amounts in column G (Data) that are under zero.

I have added a column I in Data. There are 2 devices in there that has a value of +2000. I need this somehow incorporated 'adding that value if it's selected' into the above formula. So if these are picked in the same manor as all the other equipment then it adds it to the total of S5.

For example, in the attached I have added a piece of equipment in J5 (takeoff) that has a value of 2000 in column I (Data). At present the total in S5 reads -5100. I need to adapt the formula so it makes it -3100.

Any Help will be appreciated.

Cheers

Sam

Try:

=SUMPRODUCT(SUMIFS(Data!G:G,Data!A:A,$G$4:$O$4,Data!G:G,"<0"),$G5:$O5)+SUMPRODUCT(SUMIF(Data!A:A,$G$4:$O$4,Data!I:I)*($G5:$O5))