help with sales formula
 

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

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)

help with sales formula
 

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)

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.

help with sales formula
 

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)