Unable to use SUMIFS with INDIRECT together

Hello

I use this formula, and i get some results from another sheet(sheet name =test) that works great

Formula:

Please Login or Register  to view this content.

As i have many sheets that i would like to choose the sheet that i like to get the results, i put the sheet name in B1 and tried to use the INDIRECT function. This gives me a mistake.

Does anyone see any mistake in my formula?

Formula:

Please Login or Register  to view this content.

Thanks in advance for any help here.

YES!!

This works!!

Thank you!!

Just for information. What was my mistake? I am not able to find it!