Thread: multiply arrays
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
  
Posts: 15,768
Default multiply arrays
=SUMPRODUCT(SUMIF(D110:D114,{"0"},G110:G114*'R OI Questions'!B34:B38))

Maybe this:

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

--
Biff
Microsoft Excel MVP


"Gary" wrote in message
...
What's wrong with this formula?

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


Reply With QuoteReply With Quote