sums from another tab

  • Thread starter Thread starter tonyrulesyall
  • Start date Start date
T

tonyrulesyall

I am using Excel XP.

I am using a series of formulas as a template for the report,
week to week.

I have a cell two columns immediately to the left with a total.

The cell that I am in refers to the cell two columns to the left.
It takes the total of all the values in the current column and divides
it by them.

I would like the formula to look something like this:

=sum($e$1:$e$[one cell above])/$c[two cells to the left]

How would I do this?
 
I am using Excel XP.

I am using a series of formulas as a template for the report,
week to week.

I have a cell two columns immediately to the left with a total.

The cell that I am in refers to the cell two columns to the left.
It takes the total of all the values in the current column and divides
it by them.

I would like the formula to look something like this:

=sum($e$1:$e$[one cell above])/$c[two cells to the left]

How would I do this?
Click to expand...

U can do sth like
=sum(indirect(concatenate("$e$1:$e$",row(current cell e.g.A7)-1)))/
indirect(concatenate("$c",column(current cell e.g. A7)) +2)
 
Try this, starting in E2:

=SUM($E$1:E1)/C2

And copy down as needed.

This formula is very resource intensive.
Wouldn't recommend it for situations in excess of 5,000 rows.
 
Back
Top