Data Consolidation [Closed]

Question

Data Consolidation [Closed]

Report

Karthikeyan1207

Posts: 18
Registration date: Wednesday November 26, 2014
Status: Member
Last seen: August 3, 2020

- May 8, 2015 at 05:23 AM
TrowaD

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

- May 19, 2015 at 12:00 PM

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

Data Consolidation
Digital data transmission - Articles
The ____________ transports memory addresses which the processor wants to access in order to read or write data) - Articles
Transfer data from one excel worksheet to another automatically - How-To - Excel
Macro to copy data from one sheet to another based on criteria ✓ - Forum - Excel
Paste data below the last used row - How-To - Excel

1 reply

Ask a question

TrowaD · Answer 1 · 2015-05-19T12:00:06-0400

Answer 1 / 1

TrowaD

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

457
May 19, 2015 at 12:00 PM

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

Data Consolidation [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!