Sum multiple sheets with indirect function

[cshetty]

Dear Experts
I have a workbook which has sheets from Jan to Dec. and one combined sheet for the year.

Since it is the beginning of the year, now I have only 01-23 sheet.

My formula works fine when all the sheets are present.

=SUMPRODUCT(SUMIF(INDIRECT("'"&$U$4:$U$15&"'!$B$4:$B$600"),B21,INDIRECT("'"&$U$4:$U$15&"'!$N$4:$N$600")))

U4:U15 names of sheets for all the 12 months.

Is there any way to tune the formula to ignore the sheets which are not yet created on the workbook.

Thanks in advance

 

[cshetty]

Dear Experts
I have a workbook which has sheets from Jan to Dec. and one combined sheet for the year.

Since it is the beginning of the year, now I have only 01-23 sheet.

My formula works fine when all the sheets are present.

=SUMPRODUCT(SUMIF(INDIRECT("'"&$U$4:$U$15&"'!$B$4:$B$600"),B21,INDIRECT("'"&$U$4:$U$15&"'!$N$4:$N$600")))

U4:U15 names of sheets for all the 12 months.

Is there any way to tune the formula to ignore the sheets which are not yet created on the workbook.

Thanks in advance

Managed to sort this out using offset function on list of sheets based on current month.