Help

  • Thread starter Thread starter qiong
  • Start date Start date
Q

qiong

Hi,

I am currently working on a thesis which involves intensive data
management. I have a problem.

I want to type in say cell IN8 the formula:
(1/IL8)* SUM(C8, F8, I8, L8, O8, R8)
and in IN9:
(1/IL9)* SUM(F9, I9, L9, O9, R9, U9)
and in IN10:
(1/IL10)* SUM(I10, L10, O10, R10, U10, X10)
and so on...

I can't get AutoFill to efficiently fill the cells with the desired
formulas. Is there any way I can get round this?

Thanks in advance
Keng
 
I am currently working on a thesis which involves
intensive data management. I have a problem.

I want to type in say cell IN8 the formula:
(1/IL8)* SUM(C8, F8, I8, L8, O8, R8)
and in IN9:
(1/IL9)* SUM(F9, I9, L9, O9, R9, U9)
and in IN10:
(1/IL10)* SUM(I10, L10, O10, R10, U10, X10)
and so on...

I can't get AutoFill to efficiently fill the cells
with the desired formulas. Is there any way I can
get round this?
Click to expand...

I can't see a pattern for the column shift in the sum
part of your formula. The first formula starts with
column C(8), the second starts with f(9) and the third
with I(10). C, F, and I? Unless the next one is J, I
don't get it. And if it is, what's next?

Jordon
 
hello,
Have you tried using absolute formulas? That way
autofill can add it up correctly, without the error
message #Name? ...ex..(1/$IL$8)*SUM($C8,$F8..and so on)
hope this helps...


Chameleon
 
Bascially, in the nth formula in the nth row, I would want the first
cell in the (n-1)th forumla in the cell above to drop out. And the next
cell in sequence to be added.

Hence, in (n-1)th cell IN8,
(1/IL8)* SUM(C8, F8, I8, L8, O8, R8)
in nth cell IN9,
(1/IL9)* SUM(F9, I9, L9, O9, R9, U9)

C8 drops out. And U9 is added.

In (n+1)th cell IN10,
(1/IL10)* SUM(I10, L10, O10, R10, U10, X10)

F9 drops out. X10 is added.

In (n+2)th cell IN11,
(1/IL11)*SUM(L11, O11, R11, U11, X11, AA11)

I10 drops out. AA11 is added.

And so on.

Keng
 
Hi Keng,
You may be able to use the INDIRECT() function to set up a "starter cell"
and with COLUMNS() & ROWS() progress from there.

Using VBA to build, copy & paste your formula would be easier.
 
Back
Top