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.
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.