You could just as easily reference an input cell to make things more dynamic. How to do 3D averaging in Excel When you’re working with multiple sheets, there’s good news and there’s bad news.

We often have Excel workbooks where we separate out categories of similar data into separate tabs. However, using formulas on cells in every tab can get very cumbersome. And if you add a new tab, the ...