Hi all...

I hope someone can help me with the following.

At an earlier date I have seen a summary of a cell across sheets (eg. B24 in 10 sheets), using a formula (something like =sum(Sheet1:Sheet10!B24).
The idea was to get a sum of the values in Cell B24, in all sheets between Sheet 1 and Sheet 10, but I can’t reconstruct the formula. Can anybody help me?

Do I need to activate a function to get it to work?

Next step would be to exchange Sum with Min and get the minimum value of the Cell in the sheets.

The reason for doing this is that I have 1500 cell's i need to check and I have a dynamic number of Sheets that change from week to week (some min(Sheet1B24;Sheet2B24... is not possible)
I hope someone can help me, thanks in advance

Best regards

Jesper