Data Consolidation [Closed]

Report
Posts
18
Registration date
Wednesday November 26, 2014
Status
Member
Last seen
August 3, 2020
-
Posts
2700
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
February 25, 2021
-
Hi Team
I have a set of data in Sheet 1 ( Data vs value ) . I want to consolidate the value according to its data in the same sheet. This can be done in Pivot but I am looking for an option / formula to get the result in the same sheet , instead of getting it through Pivot from other sheet .

Input E.g :
Data Value
A 1
B 1
A 2
B 3
C 1
C 1
A 1

Result looking for ( in the same sheet somewhere are the right side ) :

A 4
B 4
C 2

Pls help if you have any option

Regards
Karthikeyan

1 reply

Posts
2700
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
February 25, 2021
457
Hi Karthikeyan,

What you are looking for is the formula called SUMIF.

Give it a go and let us know if and where you get stuck.

Best regards,
Trowa

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!