No need to hope:

=SUM(INDIRECT("R7C"&COLUMN()&":R"&COLUMNS($F$7:F7) +6&"C"&COLUMN(),0))*$B$79


Sean Timmons wrote:
I was thinkign sometign along those liens too, but notice the H67 needs to
include cell H9, so the source increases as we go..

Try this way:

=SUMPRODUCT($F$7:F60*$B$79)

Assuming the last column goes as low as row 60 and hoping no extra values
popping up between rows 7 and 60.

"Glenn" wrote:

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)