Hello Biff,

That was intentional. I was trying to answer the way he had asked the
question...

I did point out that
=SUMPRODUCT(--(D110:D1140),G110:G114,('ROI Questions'!B34:B38))
will also give you the same result, since multiplying zero values won't
add
up anything.

Regards,
Sheeloo

"T. Valko" wrote:

=SUMPRODUCT(--(D110:D1140),G110:G114,--('ROI Questions'!B34:B38),('ROI
Questions'!B34:B38))

You've repeated the last array:

....--('ROI Questions'!B34:B38),('ROI Questions'!B34:B38)

Maybe this is what they're after:

=SUMPRODUCT(--(D110:D1140),G110:G114,'ROI Questions'!B34:B38)


--
Biff
Microsoft Excel MVP


"Sheeloo" wrote in message
...
Try
=SUMPRODUCT(--(D110:D1140),G110:G114,--('ROI Questions'!B34:B38),('ROI
Questions'!B34:B38))

This will multiply the corresoponding elements of Col D and ROI Col B and
then SUM them, when both are greater than zero. In fact
=SUMPRODUCT(--(D110:D1140),G110:G114,('ROI Questions'!B34:B38))
will also give you the same result, since multiplying zero values won't
add
up anything.

"Gary" wrote:

I'm simply trying to sum the product of multiplying two arrays on the
same
spreadsheet when both columns are <0. If I can do that, then I want to
try
to multiply and sum arrays on two different spreadsheets in the some
workbook.

"Sheeloo" wrote:

In
=SUMPRODUCT(SUMIF(D110:D114,{"0"},G110:G114*'ROI Questions'!B34:B38))
replace "0"} with "0"
Add ) after G114 and ( before 'ROI
in other words try
=SUMPRODUCT(SUMIF(D110:D114,"0",G110:G114)*('ROI Questions'!B34:B38))

What do you actually want to calculate?

"Gary" wrote:

What's wrong with this formula?

=SUMPRODUCT(SUMIF(D110:D114,{"0"},G110:G114*'ROI
Questions'!B34:B38))