Forum Discussion
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,COL...
=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.