Sum of Rows with Matching Cell Identifier

Good afternoon, I am looking for a formula, NOT a Pivot Table, to complete the following: Find the sum of all (VALUE) rows matching by all (EMPLOYEE ID) rows. So for the example below, my ideal...

excel

Subodh_Tiwari_sktneer
Sep 30, 2019
Deleted
If your data is setup like below...

You may try the SUMIF function to get the desired output....
=SUMIF(A:A,D2,B:B)
The above formula assumes that the Employee IDs are placed in column A and Values are places in column B and the D2 contains the lookup Employee ID.

If your data is setup differently, change the range reference in the formula as required.

Subodh_Tiwari_sktneer

Silver Contributor

Sep 30, 2019

Deleted

If your data is setup like below...

You may try the SUMIF function to get the desired output....

=SUMIF(A:A,D2,B:B)

The above formula assumes that the Employee IDs are placed in column A and Values are places in column B and the D2 contains the lookup Employee ID.

If your data is setup differently, change the range reference in the formula as required.

Anonymous

Sep 30, 2019

Subodh_Tiwari_sktneer Thank you very much! So much easier than I anticipated. I appreciate your answer.

Subodh_Tiwari_sktneer
Silver Contributor
Sep 30, 2019
You're welcome! Glad I could help.

Forum Discussion

Sum of Rows with Matching Cell Identifier

Resources