indirect function

Hi all, I have come across this formula, INDIRECT, and think it may help me with the tedious task of returning the SUM of a column in a worksheet via a cell that names that worksheet. But for the life of me i cannot figure it out...any help would be much appreciated. so...in sheet1 I have the...

I have several templates that analyze data using charts and tables. I was challenged to "speed up" the process - therefore, I used "data from other sources" to link workbooks that are out on a shared drive to quickly access current data. My most complex template has 48 links. The linked data...

I have the following function in a worksheet. This is repeated multiple time. It works. =IF(ISNA(VLOOKUP($C14,'PL 2'!$B$2:$Y$128,5,)),0,VLOOKUP($C14,'PL 2'!$B$2:$Y$128,5,))*R$2 Each column refers to a different sheet, from "PL 1" to "PL 50" at present. I have tried to make it more general...

I’m trying to make INDIRECT work with STDEV and IF. This works fine: =AVERAGEIF(INDIRECT($A$23),C29,INDIRECT($B$23)) So does this: =COUNTIF(INDIRECT($A$23),C29) And this (without INDIRECT): {=STDEV.P(IF(OOData!$G$34:$G$5686=$C29,OOData!$CG$34:$CG$5686))} I’d like to change the...

I have 2007 and have set up what is likely more convoluted worksheet than necessary however I think I am close to achieving what I was hoping for and have run into a problem. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I have a “data” worksheet with a...

There has to be a simple answer to this only I cant see it. I have a tab which contains 1700+ rows by 110 weeks worth of data. On another tab I have a calculator page where: I am allowing the user to chose a start and end date via drop downs boxes and a list products. Against each product, I...

Dear users, I am looking to create a summary worksheet using the indirect function to collect "Prices" from several tabs in the same worksheet. As I have about 40 workbooks to do this for, I want to create a Summary Template I can copy and paste into the other workbooks: As seen in MrExcel #...

Hi all, I couldn't figure out the syntax to use to specify that all the keywords must be present in search results, so I may have missed a past topic dealing with this. If so, sorry about that. My problem is as follows: When I use (for instance) Row(1:5) inside a Sum array formula...

Basically I have a formula like this: =INDIRECT($A1&"!B1") this works just fine, but I would like to copy the formula down the column and get something like this: =INDIRECT($A1&"!B2") =INDIRECT($A1&"!B3") =INDIRECT($A1&"!B4") I will also need to copy the formula across the row to get this...

Hi I have a problem using the function Indirect within VBA. I am trying to insert the formula below using VBA. I know why I have the problem. The apostrophes are causing the formula to comment out. I don't know how to get around this if you can at all. I have tried replacing the apostrophe with...

I have created a model that updates each day and pulls quotes from a certain number of days. Depending on what number of days i put in, an indirect function will generate a location to end the data pull. For instance if i put 10 days it will generate A11 in a cell. I would then pull A1:A11...

I am having problems using match and index with INDIRECT and I cant see why. Cell G1 is populated in VBA when the new weeks sheet is created. 'retain previous worksheet name for Saturday calcs Range("G1") = "''" + WS.Name + "'!" The reason for not using a direct link to the cells...

I am having a problem getting this formula to work, i have 3 cells of text that at the beginning has a date in the same cell as the text. eg; A1: 9/26/2009 this is test A, B1: 10/10/09 This is test B, C1: 9/4/09 This is test C. i am trying to find a way to fill a cell with the contents of the...

I have a formula written as text in a cell, ie. '=10+5. This formula is in real life much longer, but just think of it as a formula. In another cell, I want to insert the text (=10+5) as a formula, and consequently get the result of the formula (15). Indirect does not seem to do the trick...

I'm trying to use the "Indirect" function with a combo box, but when I attempt to put in my formula in the properties of the combo box control I get "Reference is not valid." Is it posible to use functions inside of a Control? If not how else can I do this? What I have is two combo controls...