help with sales formula
Matthew wrote:
Can someone inform me how to write the appropriate formula to assist
in my efforts to simplify my efforts - I am currently writing in each
cell the following sequence of formulas:
=F7*$B$79 in cell F67
=G7*$B$79+G8*($B$79) in cell G67
=H7*$B$79+H8*($B$79)+H9*($B$79) in cell H67
As I move across horizontally on the spreadsheet I would like to type
one formula and copy it across - can anyone assist
=SUMPRODUCT($F$7:F7*$B$79)
|