Table Name

[drchris]

Hello excel gurus

I have a question regarding table names.

I have the following formula returning a value from a defined ["TeamJan15"] table: =SUMIF(TeamJan15Tab[Team:],B3,TeamJan15Tab[Days])

However I want to use the column value as part of the table name

My columns are named Jan15, Feb15 and so on.

I tried using concatenate as below but I have a suspicion that I cannot construct the tab name; as this is stored in excel somewhere.

=SUMIF((CONCATENATE("Team",C$1,"Tab"))[Team:],B3,TeamJan15Tab[Days])

How do I carry this out?
Thanks
Christos

[mcmahobt]

You can use INDIRECT to reference actual cell ranges from different parts of a workbook. However, I'm not sure how they interact with table headings (but you can simply use the hard coded cell ranges for the table instead).

[drchris]

Thank you mcmahobt!

So how do you suggest I could construct this using INDIRECT
=SUMIF(TeamJan15Tab[Team:],B3,TeamJan15Tab[Days])

Thanks
Christos

[mcmahobt]

Personally, I don't like using Table Headers because I find them bulky. Is your table dynamic, forcing you to use Table Headers? If not, I'd suggest just using cell references. However, to use the INDIRECT function, it would be something like this:

Please Login or Register  to view this content.

Then again, it doesn't look like you need to use indirect at all if you are within the same workbook; why don't you just reference the range using your mouse?

What does that return?

[drchris]

Ill give that a go tomorrow morning when Im at work and let you know. You have a point about table headers being bulky. I could have just used reference - but it just made it easier since I had multiple monthly tabs of the same information to be able to refer to them in the "main" sheet pretty easily.
Thank you though. I'll keep you posted!
Chris