Adding single cell values across selected sheets in Excel If you want to add values across some selected sheets in Excel, you cannot use the above formula because it contains the colon.

You can sum up entire columns or rows in Microsoft Excel using the AutoSum feature. The AutoSum tool automatically selects a column or row of numbers, but you can select any set of numbers by ...