Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Table function within Excel .. please help to explain

Status
Not open for further replies.

axilla2

IS-IT--Management
Jan 24, 2003
11
GB
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.
 
Check the help file index for "data tables" to find out what sort of animal you are working with.

Specifically, look for the topic "Create a one-variable data table"

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top