Thanks Luke!
Glad to hear an explanation to the problem although I am afraid that I can't solve it in such an elegant way as I had imagined this time.
Let's just hope that Microsoft will generalize the formulas in future versions of Excel for more 3D compatibility.
Hello,
Here's a little challenge for all excel freaks out there. I am trying to make a conditional sum over multiple sheets. Each sheet lists the costs for a different work package of my project.
A simple sum works perfect:
=SUM(Sheet2:Sheet3!G:G) ' Sums correctly all costs listed in...