Tag Archives: 3D SUM

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

Posted on July 11, 2015 by MF

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 , , | 31 Comments

SUM across different worksheets (aka 3D SUM)

Posted on April 9, 2014 by MF

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