I'm having trouble with the Indirect() function. I put the following formula:
=SUMIFS(INDIRECT(D6),Evaluation_Metric,"="&B$9,Calculation,"="&C$9)
D6 = Week_1_Jan-11
B9 = LOSS_RESERVE
C9 = ITD
So I'm trying to ask, in the 1st Week in January, what is the total Loss Reserve for the Incurred To Date calculation?
The formula returns "#REF!". Why is it returning "#REF!"? Is there a rule that the text string it is evaluating cannot have a number in it? I'm coming to the end of very long spreadsheet building process and this not working could potentially cause a huge headache.
When I pull up the "Functions Arguments" window (click fx next to formula box). If I have INDIRECT(D6) in the "Sum_Range", the evaluation to the left says "Volatile". If I type, Week_1_Jan-11 it gives me a blank. If I actually go and select the desired cells, it automatically inputs a variation of the Defined Names (Week_1_Jan_11) but doesn't return any results.
Can someone please help?
Bookmarks