Hello all,
Firstly i'm not sure if what I want to do is possible, i have looked at various options as exhaustively as I can but my syntax is woeful at best.
I have a SUMIFS formula that works for individual sheets in a wookbook but I need to be able to use it across multiple sheets, which i think might be achievable with name manager (Sheets)? I'm using the SUMIFS with criteria 1 & 2 to restrict date ranges, which in the first instance would be for uk tax year if sheets can be incorporated, but if possible then would also be used for monthly range as the sheets run middle of the month to middle.
=SUMIFS('Apr-May ''24'!F3:F32,'Apr-May ''24'!A3:A32, ">=6/4/2024", 'Apr-May ''24'!A3:A32, "<=5/4/2025")
Any input is appreciated, thank you.
Firstly i'm not sure if what I want to do is possible, i have looked at various options as exhaustively as I can but my syntax is woeful at best.
I have a SUMIFS formula that works for individual sheets in a wookbook but I need to be able to use it across multiple sheets, which i think might be achievable with name manager (Sheets)? I'm using the SUMIFS with criteria 1 & 2 to restrict date ranges, which in the first instance would be for uk tax year if sheets can be incorporated, but if possible then would also be used for monthly range as the sheets run middle of the month to middle.
=SUMIFS('Apr-May ''24'!F3:F32,'Apr-May ''24'!A3:A32, ">=6/4/2024", 'Apr-May ''24'!A3:A32, "<=5/4/2025")
Any input is appreciated, thank you.
