Aug 07 2017
09:27 AM
- last edited on
Jul 25 2018
09:53 AM
by
TechCommunityAP
Aug 07 2017
09:27 AM
- last edited on
Jul 25 2018
09:53 AM
by
TechCommunityAP
I am trying to multiply row 2 by row 1 and then sum the results. BUT, I want to start the multiplication of row 2 at the start of row 1.
I have tried sumproduct on its own and using CSE, but I think I am not using the correct formula. Any ideas?
Aug 07 2017 11:11 AM
SolutionHi Richard,
That could be something like this
=SUMPRODUCT($C4:C4,N(OFFSET($C5:C5,0,COLUMN(C5)-COLUMN($C5:C5))))
Aug 07 2017 11:11 AM
SolutionHi Richard,
That could be something like this
=SUMPRODUCT($C4:C4,N(OFFSET($C5:C5,0,COLUMN(C5)-COLUMN($C5:C5))))