Skip to Content
0
Former Member
May 26, 2015 at 05:22 AM

How to add sum of two matching rows

16 Views

col1 col2 col3 AGGREATE 1100 3 10 90 2200 3 20 20 3300 3 30 30 1100 6 40 40 2200 6 50 110 3300 6 60 60 4400 9 70 70 1100 3 80 2200 6 90 4400 9 100

170

Hi Experts,

Here having 3 columns,we have find col 1 and col2 are repeated the need to aggregate values in col3 hav to is dispaly in Aggregate column.

col1 having 1100 multiple times,but need to check how times repeated with col2.

col1 :1100 and col2 : 3 -> 2 Times Repeated.

Then need to add values in col3 and have to display in Aggreate column.

10+80=90

can you please help how validate formula step by step

Thanks & Regards,

Kris