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
=sum($d$4*d6)+($e$4*e6)+($f$4*f6)...... I'm trying to multiply and add up columns across the spreadsheet.
Scott