Forum Discussion
Multiply two rows and add all
Can anyone help me please is there a quicker way to =I14*C14+I15*C15 in have 2500 cells to do, then i need to repeat the formula to another colomn 30 times for =J14*C14+J15*C15' , =K14*C14+K15*C15...
Hi,
You have not specified where you want to put formula. Anyway try the formula as below.
=I14*$C14+I15*$C15
=J14*$C14+J15*$C15
=K14*$C14+K15*$C15
the formula is at the bottom of the sheet under the corresponding date. Sorry I missed that out