On Sep 28, 4:28*pm, 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)

More specifically, I am calculating a revenue share between two
entities and in the first year of sales the split is 70%/30% then 2nd
year 60%/40% then 3rd yr 50%/50% then 4th yr 40%/60% then 5th yr 30%/
70%. hence in month 13 the revenue share of each client changes to
60/40 in month 25 its 50%/50% etc. I am trying to put together a
monthly running revenue total. All along the five years new clients
are added each month.