Using table column reference in Indirect function

[Strugling]

I have different tabs for each student, with the same table on each with different data.
I have a main dashboard tab that I want separate data from each student from different dates.
1. What is wrong with my "Jan Hours function" and can I use indirect?
2. How can I use the column name [Hours] in Indirect to get totals?
https://1drv.ms/x/s!Asw9lwmh6RVagd1mMZifk_BP1m-Ndg

 

[Special-K99]

#NAME means your formula or UDF does not exist, specifically dateMONTH, whatever that is

I dont see Hours listed either

 

[wideboydixon]

Book1
	C	D	E	F	G
1		1	2	3
2	Student	Jan Hours	Feb Hours	Mar Hours	Total
3	Ed	10.5	20.5	6.5	37.5
4	Susy	9	23	12	44
Main

Cell Formulas
Range	Formula
D3	=SUMPRODUCT(--(MONTH(INDIRECT([@Student]&"T[Date]"))=D$1),INDIRECT([@Student]&"T[Hours]"))
E3	=SUMPRODUCT(--(MONTH(INDIRECT([@Student]&"T[Date]"))=E$1),INDIRECT([@Student]&"T[Hours]"))
F3	=SUMPRODUCT(--(MONTH(INDIRECT([@Student]&"T[Date]"))=F$1),INDIRECT([@Student]&"T[Hours]"))
G3	=SUM(INDIRECT([@Student]&"T[Hours]"))

WBD

 

[Strugling]

#NAME means your formula or UDF does not exist, specifically dateMONTH, whatever that is

I dont see Hours listed either

my formula is =SUMIF(MONTH(EdT[Date]),D1,EdT[Hours])
where EdT is the table on tab Ed.
and the Hours is on the Ed and Susy tabs.

 

[wideboydixon]

Bump - just in case you didn't see my post above

WBD

 

[Strugling]

Exactly what I need!!
Thank you so very much!!