Use index in table header with sumifs

[lofgren]

Hello all,

So I have this formula:

=SUMIFS(PLAN_LAB!$K:$K;PLAN_LAB!$B:$B;">="&DATE($C1;C$2;1);PLAN_LAB!$B:$B;"<="&DATE($C$1;C$2+1)

Considering the fact that on sheet Plan_lab I have one table (Table1), i would like to use index in table header in order to find the column instead of writing the range (PLAN_LAB!$K:$K).

Any chance you could help me?

[AliGW]

There are instructions at the top of the page explaining how to attach your sample workbook.

[lofgren]

Sorry about that, i forgot to attach the file
First post updated

[JeteMc]

Try pasting the following into cell C4 and then drag the fill handle over and down to cell N6:

Please Login or Register  to view this content.

Let us know if you have any questions.

[BMV]

Please Login or Register  to view this content.

[Fluff13]

Another option
=SUMIFS(INDEX(Table1,,MATCH($B4,Table1[#Headers],0)),Table1[[date]:[date]],">="&DATE($C$1,C$2,1),Table1[[date]:[date]],"<"&DATE($C$1,C$2+1,1))