Sep 30 2019 09:23 AM
Sep 30 2019 09:23 AM
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 result would show that Employee ID # 1201 has a total of 7, where Employee ID #1426 has a total of 10.
Employee ID # | Value |
1201 | 5 |
1426 | 10 |
1201 | 2 |
Sep 30 2019 09:29 AM
Sep 30 2019 09:57 AM
Solution@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.
Sep 30 2019 09:58 AM
@Deleted
Good afternoon,
You are looking for a formula, NOT a Pivot Table, to sum of all (VALUE) rows matching by all (EMPLOYEE ID) rows as per your below example and the ideal result should be 7 for Employee ID # 1201.
You can use "SUMIF" as shown in illustration below:
Sep 30 2019 12:23 PM
@Subodh_Tiwari_sktneer Thank you very much! So much easier than I anticipated. I appreciate your answer.
Sep 30 2019 12:35 PM
You're welcome! Glad I could help.
Dec 07 2023 12:59 PM
@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.
Sep 30 2019 09:57 AM
Solution@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.