Tag Archives: 3D SUM

=SUM(‘???’!C3) Is it a valid formula?? No. It is magical indeed!

This is about using wildcards in referencing cells on other worksheets. If you know the basic rule about naming a worksheet, you should know that we cannot use ? or * in any part of a worksheet’s name.  So there … Continue reading

Rate this:

Posted in Excel Tips, Formula | Tagged , , | 30 Comments

SUM across different worksheets (aka 3D SUM)

Did you ever make a formula like the one below?  After reading this post, I hope you will never make a formula in this way again.

Rate this:

Posted in Excel Tips, Formula | Tagged | 9 Comments