Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill an Indirect Statement
I need to add Indirect to 5000 rows of formula. So, with the following
formula, how can I get it to fill with the correct cell references(T2 becomes T3 and Z2 becomes Z3 and so on down the column)? =SUM(INDIRECT("Allocate!T2")+INDIRECT("Allocate!Z2 ")) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill an Indirect Statement
=SUM(INDIRECT("Allocate!T"&ROW(A2))+INDIRECT("Allo cate!Z"&ROW(A2)))
-- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "D" wrote in message ... I need to add Indirect to 5000 rows of formula. So, with the following formula, how can I get it to fill with the correct cell references(T2 becomes T3 and Z2 becomes Z3 and so on down the column)? =SUM(INDIRECT("Allocate!T2")+INDIRECT("Allocate!Z2 ")) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill an Indirect Statement
Thank you for your response but this didn't seem to work. I have tried wild
cards in find and replace but have been unable to get that to work either. Any other suggestions? "Bob Phillips" wrote: =SUM(INDIRECT("Allocate!T"&ROW(A2))+INDIRECT("Allo cate!Z"&ROW(A2))) -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "D" wrote in message ... I need to add Indirect to 5000 rows of formula. So, with the following formula, how can I get it to fill with the correct cell references(T2 becomes T3 and Z2 becomes Z3 and so on down the column)? =SUM(INDIRECT("Allocate!T2")+INDIRECT("Allocate!Z2 ")) |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill an Indirect Statement
Yes, it did work! So SORRY!! Not quite sure why it works but it does and
that makes this project so much easier. "Bob Phillips" wrote: =SUM(INDIRECT("Allocate!T"&ROW(A2))+INDIRECT("Allo cate!Z"&ROW(A2))) -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "D" wrote in message ... I need to add Indirect to 5000 rows of formula. So, with the following formula, how can I get it to fill with the correct cell references(T2 becomes T3 and Z2 becomes Z3 and so on down the column)? =SUM(INDIRECT("Allocate!T2")+INDIRECT("Allocate!Z2 ")) |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill an Indirect Statement
One thing to note is that indirect is volatile meaning that this formula will
recalculate with every calculation in XL. This could will be a fairly large performance hit and things may respond quite slowly... -- HTH... Jim Thomlinson "D" wrote: Yes, it did work! So SORRY!! Not quite sure why it works but it does and that makes this project so much easier. "Bob Phillips" wrote: =SUM(INDIRECT("Allocate!T"&ROW(A2))+INDIRECT("Allo cate!Z"&ROW(A2))) -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "D" wrote in message ... I need to add Indirect to 5000 rows of formula. So, with the following formula, how can I get it to fill with the correct cell references(T2 becomes T3 and Z2 becomes Z3 and so on down the column)? =SUM(INDIRECT("Allocate!T2")+INDIRECT("Allocate!Z2 ")) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Indirect ref in array formulas | Excel Worksheet Functions | |||
Excel printing problem - won't print cell under a "fill effect" bo | Excel Discussion (Misc queries) | |||
Fill Color Red | Excel Discussion (Misc queries) | |||
Fill colour red | Excel Discussion (Misc queries) | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions |