Share via

Microsoft 365, Excel: How to check a column's reference #'s and add the matching values in another column

Kevin JD 0 Reputation points
2026-04-04T16:14:12.8+00:00

Excel Spreadsheet, using rows 2-175. Column B=$ value, Column C = Reference # (approximately 10 of them, using 1010 as a reference in this case).

Am trying to add a formula at the end of spreadsheet to check all of C cells and if they equal 1010, then the value in the Corresponding B cells are added up and ignoring the other Column C cells value.

Microsoft 365 and Office | Excel | Other | Other
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest

  1. AI answer

    2026-04-04T16:14:23.6466667+00:00

    Use the SUMIF function to total values in column B only when the corresponding reference in column C equals 1010.

    Assuming:

    • Values are in B2:B175
    • Reference numbers are in C2:C175
    • 1010 is the reference to match

    Enter this formula in the cell where the total is needed (for example, B176 or any empty cell):

    =SUMIF(C2:C175,1010,B2:B175)

    Explanation:

    • C2:C175 is the range that contains the reference numbers.
    • 1010 is the criteria (the reference number to match).
    • B2:B175 is the range of amounts to sum when the criteria is met.

    This will add up only those B values whose corresponding C value is 1010 and ignore all others.

    References:

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

    Was this answer helpful?

    1 person found 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.