Forum Discussion

Rita1340's avatar
Rita1340
Copper Contributor
Oct 03, 2024

SUMPRODUCT

Hi 

Im trying to get an automatic formula to get the results of cell C7, however in D7 there is an error that I can't fix. Any suggestions?

C5 formula =SUMPRODUCT($C4:C4,$C$11:INDEX($C$11:$C$16,COLUMN(C5)-COLUMN($C$4)+1))

C6 =SUMPRODUCT($C4:D4,$C$11:INDEX($C$11:$C$16,COLUMN(D5)-COLUMN($C$4)+1))

expected results are in row 7, I'm trying to find a way to automate with an easy formula

 Thanks

Excel
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Gold Contributor
    Oct 03, 2024

    Rita1340 

    =MMULT($C4:C4,$C$11:INDEX($C$11:$C$16,COLUMN(C5)-COLUMN($C$4)+1))

     

    This formula works in my sample file. It's in cell C5 and copied to the right. The formula must be entered as an arrayformula with ctrl+shift+enter if someone doesn't work with Office 365 or Excel for the web or Excel 2021. By the way i don't understand the expected results.

     

Resources