Multi Sheets

[mcgrath1980]

Hi

I am using the following SUMIF('01012019'!$I$1:$I$1000,"GRID",'01012019'!$F$1:$F$1009)

I need to pick up info from each tab on my sheet dating 01012019 to 31012019.

my question is : Is there an easy way to do this ?? Or would I have to go into every sheet.


Thanks

 

[FormR]

Post 6 now..... Each tab on the sheet is numbered 010119 - 020119 - 030119 - 040119 and so on until 310119

Thanks for clarifying, you can try:

=SUMPRODUCT(SUMIF(INDIRECT(TEXT(ROW(INDIRECT(DATE(2019,1,1)&":"&DATE(2019,1,31))),"ddmmyy")&"!$I$1:$I$1000"),"GRID",INDIRECT(TEXT(ROW(INDIRECT(DATE(2019,1,1)&":"&DATE(2019,1,31))),"ddmmyy")&"!$F$1:$F$1009")))

 

[mcgrath1980]

Thank you.