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

​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  Read More

​