Adding multiple things on multiple pages

K 20 Reputation points
2026-04-18T17:24:37.44+00:00

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

Microsoft 365 and Office | Excel | For home | Windows
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest

  1. AI answer

    2026-04-18T17:24:48.7233333+00:00

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

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

    • Column A: Date
    • Column B: Check number
    • Column C: Name of place (e.g., Discover, John Doe)
    • Column D: Withdrawal amount

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

    • A2: Discover
    • A3: John Doe

    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:

    • Discover — 60 + 20 = 80
    • John Doe — 20 + 10 = 30

    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:

    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.