ADDINg "INDIRECT" TO EXISTING SUMIFS FORMULA

[JuicyMusic]

I am still trying to insert the INDIRECT argument to a SUMIFS formula.
The tab names on the Summary sheet are in Column B. They are month names from January to December. The other tab names are from January to December as well.

How do I insert INDIRECT please?

Here is my existing formula looking at the tab named January (for an example):

=IFERROR(SUMIFS(January!$T$14:$T$2000,January!$R$14:$R$2000,$A7,January!$S$14:$S$2000,G$6),0)

Thank you so much! Juicy

 

[Fluff]

Which cell has the tab name in it?

 

[JuicyMusic]

Cell B7 thru B18 - for January to December. Month names spelt out.

 

[Fluff]

How about

=IFERROR(SUMIFS(INDIRECT("'"&B7&"'!$T$14:$T$2000"),INDIRECT("'"&B7&"'!$R$14:$R$2000"),$A7,INDIRECT("'"&B7&"'!$s$14:$s$2000"),G$6),0)

 

[JuicyMusic]

Whaaaaaaa.........I was inserting INDIRECT while waiting for your response. You beat me too it, of course .......SOLVED~~~~~

I know now to insert it before that arguments that point to another tab. THANK YOU !!!

 

[Fluff]

Your welcome & thanks for the feedback.