• 469K Members
• 4,760 Online
• 567K Conversations
SOLVED

Deleted
Not applicable

# 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 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
5 Replies

# Re: Sum of Rows with Matching Cell Identifier

This could be accomplished with a simple SUMIF() formula.
Solution

# Re: Sum of Rows with Matching Cell Identifier

@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.

# Re: Sum of Rows with Matching Cell Identifier

@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:

# Re: Sum of Rows with Matching Cell Identifier

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

# Re: Sum of Rows with Matching Cell Identifier

You're welcome! Glad I could help.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies