Forum Discussion

Anonymous

Sep 30, 2019

Solved

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.

Shelbie2260

Copper Contributor

Dec 07, 2023

Subodh_Tiwari_sktneer hey this was very helpful. I have a running list of employees (500+ rows) that I need sums per employee but when I do this it gives me a running list of totals. Is there a way to get only one total per employee?
In your example if #1201 has multiple rows under Value it would sum it per line.