WORKSHEET FORMULA TIPS
Excel allows you to make 3D formulas based on the following syntax:
However, the functions that can actually use that syntax are limited
(although not as limited as the Excel documentation would lead you to
believe). I put together the following list of functions that represent
most, but probably not all, of those that are 3D-enabled:
AVERAGE, AVERAGEA, COUNT, COUNTA, MAX, MAXA, MIN, MINA, PRODUCT, STDEV,
STDEVA, STDEVP, STDEVPA, VAR, VARA, VARP, VARPA, SMALL, LARGE, RANK,
MEDIAN, PERCENTILE, QUARTILE, TRIMMEAN, SKEW, AND, OR, AVEDEV, DEVSQ,
BTW, If you create a defined name for this type of 3D range, be sure to
group all of the sheets in that range if you decide to insert any rows
into the area bounded by that range (if you want your 3D range to reflect
the insertion of that row).
Editor’s Note: See Summing in 3D for an example.