Adding multiple things on multiple pages

Question

K 20

Sheet One: (Month of January)

1/2/26 (date), 777 (check number), discover (name of place), $60 (withdrawal), $100 (balance) , cleared (status-cleared bank)

1/2/26 (date), 778 (check number), John Doe (name of place), $20 (withdrawal), $80 (balance) , cleared (status-cleared bank)

Sheet Two: (Month of February)

2/2/26 (date), 779 (check number), John Doe (name of place), $10 (withdrawal), $70 (balance) , cleared (status-cleared bank)

2/3/26 (date), 780 (check number), Discover (name of place), $20 (withdrawal), $50 (balance) , cleared (status-cleared bank)

On sheet three I was it to tell me the total amount I have spend at discover and John Doe for the month of January and February. For example

Discover — $80

John Doe — $30

0 comments

1 answer

Answer 1

Use a 3‑D SUM with criteria on the payee name.

Assume this layout on each monthly sheet (January, February):

On Sheet3 (summary sheet), put the names in one column, for example:

Then use SUMIF with a 3‑D reference for the amount column:

In B2 (total for Discover across January and February):

=SUMIF(January:February!C:C, A2, January:February!D:D)

In B3 (total for John Doe across January and February):

=SUMIF(January:February!C:C, A3, January:February!D:D)

Explanation:

January:February!C:C is a 3‑D reference to the “Name of place” column on all sheets from January through February.
A2 (or A3) is the name to match (Discover or John Doe).
January:February!D:D is the 3‑D reference to the Withdrawal column to be summed.

This will return:

If sheet names contain spaces (for example January 2026 and February 2026), wrap them in apostrophes in the 3‑D reference, like:

=SUMIF('January 2026:February 2026'!C:C, A2, 'January 2026:February 2026'!D:D)

References: