Indirect Function with dash"-"

[EJAY]

Hi, I am using an indirect function where the sheet names contain a dash"-" it is a multiple sheet workbook +-70 sheets that I receive on a monthly basis.

The Formula is
=SUMIFS(INDIRECT(C3&"!$F:$F"),INDIRECT(C3&"!$A:$A"),">"&E$3,INDIRECT(C3&"!$A:$A"),"<="&E$2,INDIRECT(C3&"!B:B"),$C$4)

Where C3 is the sheet name.

Please assist with the formula? as it is tiring process to rename all the sheets on a monthly basis.

 

[Fluff]

Hi & welcome to MrExcel.
You need to wrap the sheet name in apostrophes like

INDIRECT("'"&C3&"'!$F:$F")

 

[EJAY]

Good Day Fluff,
Thank you very much it worked!!

 

[Fluff]

You're welcome & thanks for the feedback.