Adding single cell values across multiple sheets in Excel We have created sample data containing sales of 6 different companies in four consecutive months (from January to April).

From then on, any time the values changed in cells A5 or A6, the contents of cell A10 would reflect these changes as well. Warnings Information in this article applies to Excel 2013.

For example, if you want to add the values in cells A1, A2, and A3, type the below and hit Enter. =A1+A2+A3 Excel also lets you combine direct numbers and cell references in the same formula.

This way, two values written as Two and TWO will be considered distinct. 3. Using the UNIQUE Function (Excel 365 and Excel 2019) Select a cell where you want the result. Enter the formula: ...