Hi,

I need a formula that do the same as

=SUM(A:B!B5)

which sums all sheets between A and B.

My problem is that the cells to include in the summary, isn't on a fixed
place. In some sheets the value can be in B6 and the rest could be B5.

I have tried SUMIF and array formulas, but I don't get Excel to understand
where to look...

Any tips? Is it even possible?

BR
André