To sum cell B3 from all worksheets in the workbook, enter: =SUM('*' ! b3) The formula in cell D4 of the Totals worksheet sums "Units" in cell B3 (item Blue) across all the city (source) worksheets. As shown below, the 3 city sheets all have the same format. ![]() ![]() ![]() We have a destination sheet, Totals, and 3 city worksheets. Sum Across All Worksheets in the Workbook
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |