I inherited a set of spreadsheets from some developer the company hired back in 98. Trying to figure out how in hell the spreadsheet works.
It's sort of a balance sheet, so there's a lot of cross referencing going on. SUMIFs, VLOOKUPs, etc.
The thing that's doing most of the calcing in the spreadsheet is this Table function that i'm not familiar with.
I have a row of data in which the formula states: {=TABLE(,Q7)}
...with the {} around the actual formula. I'm not allowed to change any part of this field, due to error message "Cannot change part of a Table."
The formula actually does what SUMIF would normally do, in other words references a field (ex: May-03) and sums up all activity for that month on another sheet.
The reference to field Q7 is a dead end, b/c the field is blank, although Q6 is labeled MYDate (Month-Year..ok it's somethin to do with somethin....?!?@!?)
The documentation that comes in the help file is pretty slim and has taught me nothing.
Searching the MS Knowledge base produced nothing.
I'm relying on your help to please explain to me what sort of tool this Table function is and how it works.
Wish a could attach a copy, it's kinda hard to really explain it. Hoping there's an expert out there that would be able to tell me how the hell this thing works and how to modify it.
It's sort of a balance sheet, so there's a lot of cross referencing going on. SUMIFs, VLOOKUPs, etc.
The thing that's doing most of the calcing in the spreadsheet is this Table function that i'm not familiar with.
I have a row of data in which the formula states: {=TABLE(,Q7)}
...with the {} around the actual formula. I'm not allowed to change any part of this field, due to error message "Cannot change part of a Table."
The formula actually does what SUMIF would normally do, in other words references a field (ex: May-03) and sums up all activity for that month on another sheet.
The reference to field Q7 is a dead end, b/c the field is blank, although Q6 is labeled MYDate (Month-Year..ok it's somethin to do with somethin....?!?@!?)
The documentation that comes in the help file is pretty slim and has taught me nothing.
Searching the MS Knowledge base produced nothing.
I'm relying on your help to please explain to me what sort of tool this Table function is and how it works.
Wish a could attach a copy, it's kinda hard to really explain it. Hoping there's an expert out there that would be able to tell me how the hell this thing works and how to modify it.