You can combine text from multiple cells into one cell in Excel using the Ampersand symbol (&) or by using the CONCATENATE function.

You can sum cells across multiple sheets in Excel. This article presents steps for Adding single-cell values or Adding values in the range of cells.