help with sales formula

M

Matthew

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
 
G

Glenn

Matthew said:
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)
 
S

Sean Timmons

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.
 
M

Matthew

=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.
 
G

Glenn

No need to hope:

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top