Long multiplication with fixed cell

shibner

New member
Joined
Apr 11, 2014
Messages
2
Reaction score
0
Points
0
There has to be a better formula than the one below. It leaves too many opportunities to enter an incorrect cell and can be long when you have a lot of columns. Any help would be greatly appreciated.

=sum($d$4*d6)+($e$4*e6)+($f$4*f6)...... I'm trying to multiply and add up columns across the spreadsheet.

Scott
 
Try SUMPRODUCT()

e.g.

=SUMPRODUCT($D$4:$F$4,D6:F6)
 
Back
Top