View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Matthew[_4_] Matthew[_4_] is offline
external usenet poster
 
Posts: 4
Default help with sales formula

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.