Forum Discussion

Km3's avatar
Km3
Copper Contributor
Apr 15, 2026

Formula for adding multiple sheets

I am trying to add multiple things across multiple sheets.  example :  On sheet one, I have column a date, column b check number, column c name of place, column d category, column e withdrawal ...
Formulas and Functions
Olufemi7's avatar
Olufemi7
Steel Contributor
Apr 19, 2026

Hello Km3​,

Use SUMIF across each sheet and add the results together since all sheets have the same structure.

Assume A2 contains the name of place, column C contains name of place, and column E contains withdrawal amount.

For a few sheets (Sheet1 to Sheet5), use:

=SUMIF(Sheet1!C:C,A2,Sheet1!E:E)+SUMIF(Sheet2!C:C,A2,Sheet2!E:E)+SUMIF(Sheet3!C:C,A2,Sheet3!E:E)+SUMIF(Sheet4!C:C,A2,Sheet4!E:E)+SUMIF(Sheet5!C:C,A2,Sheet5!E:E)

Each sheet is calculated separately and then combined into one total.

If you have many sheets, you can list sheet names in a range like H1:H10 and use:

=SUMPRODUCT(SUMIF(INDIRECT("'"&H1:H10&"'!C:C"),A2,INDIRECT("'"&H1:H10&"'!E:E")))

Best practice is Power Query. You can append all sheets into one table and then group by Name of Place and sum Withdrawal Amount.

https://learn.microsoft.com/en-us/power-query/append-queries