adding up three tabs

Hi All, I have a simple question. I have financials across three tabs in an excel split by calendar month. I would like to consolidate all three tabs into one tab by calendar month. What it's th...

excel

Formulas and Functions

Martin_Weiss
Jan 12, 2022
Hi jepthah

there is a consolidate-function in Excel:
1. Add a new empty worksheet in your existing workbook
2. Open menu path "Data | Consolidate"
3. Choose "Sum" as a function, click in the "Reference"-field and then select the data range in the first sheet
4. Then click on "Add" and repeat this selection for the other two sheets. Make sure that the three checkboxes at the bottom are checked, then click on OK
5. You probably have to adjust the number format on the column headers, so they are shown as dates. And then you have the grouped consolidated results:

Martin_Weiss

Bronze Contributor

Jan 12, 2022

Hi jepthah

there is a consolidate-function in Excel:

1. Add a new empty worksheet in your existing workbook

2. Open menu path "Data | Consolidate"

3. Choose "Sum" as a function, click in the "Reference"-field and then select the data range in the first sheet

4. Then click on "Add" and repeat this selection for the other two sheets. Make sure that the three checkboxes at the bottom are checked, then click on OK

5. You probably have to adjust the number format on the column headers, so they are shown as dates. And then you have the grouped consolidated results:

jepthah

Copper Contributor

Jan 12, 2022

Martin_Weiss that is super helpful.

Thank you very much

Forum Discussion

adding up three tabs

Resources