hello

there are 4 sheets in workbook.

sheet name is 3-12, 3-13, 3-14, 3-17.

that 3-15, 3-16 is not because of holidays.
but, i want to display in 3-17 sheet sum of A1 cell from 3-12 sheet to 3-16 sheet.

nearly, =SUM('3-12:3-16'!A1)

=SUMPRODUCT(N(INDIRECT("'3-"&ROW(INDIRECT("12:"&RIGHT(A1,2)-3)) &"'!A6")))
is well work.. but

=SUMPRODUCT(N(INDIRECT("'3-"&ROW(INDIRECT("12:"&RIGHT(A1,2)-1)) &"'!A6")))
do not work..

i want to sum dynamic skip error value.
namely, calculating to yesterday(3-16) from first day(3-12)...