Need help in finding sum acording to unique values in diff column

[gokzee]

Hello!!

thanks for checking into this.

i have two columns A & B with similar values

column A column B

111 23
111 23
111 23
111 23
121 33
121 33
121 33
151 55
151 55

i need the sum output of column B in the following format in a cell

111 23
121 33
151 55
sum=23+33+55

thanks in advance

Gokz

[Hyperdude]

hi,

is removing duplicates an option?

[gokzee]

not actually...because there are other columns related to it.

[FDibbins]

assuming you're data is in A and B, use this in C2, copied down...

=IF(A2=A3,"",B2+SUM($D$1:D1))
or
=IF(COUNTIF(A1:$A$9,A1)>1,"",B2+SUM($D$1:D1))
It will give you a running total of unique values from B

[Steve N.]

How's about something simple...

[gokzee]

Hii FDibbins,

i dint understand the use of column D.

if you dont mind..can you explain

thanks

Gokz

[FDibbins]

I used D for the formula

[gokzee]

@steve

thanks

but due to thousands of entries..i cannot use a pivot table.


Gokz

[gokzee]

@FDibbins

It dint work as required. was generating sum even after my data in columns ended

thanks

[gokzee]

any other ideas???

[FDibbins]

ok i just noticed that the sum() part of my calc isnt working. if an extra helper column is do-able for you, use...
=IF(A1=A2,"",B1)
or
=IF(COUNTIF(A1:$A$9,A1)>1,"",B1)
copied down, then just sum the column with the formula in it

[gokzee]

ok i just noticed that the sum() part of my calc isnt working. if an extra helper column is do-able for you, use...
=IF(A1=A2,"",B1)
or
=IF(COUNTIF(A1:$A$9,A1)>1,"",B1)
copied down, then just sum the column with the formula in it

@fDibbins

sorry again..it doesnt work in the following case

1
1
1
2
2
1
1
3
3
3

i.e. when a number repeats again after a diff number(like how 1 cmes aftr 2)

thanks

gokz

[Kevin UK]

Hi

Sumproduct should acheive this;

Please Login or Register  to view this content.

Hello!!

thanks for checking into this.

i have two columns A & B with similar values

column A column B

111 23
111 23
111 23
111 23
121 33
121 33
121 33
151 55
151 55

i need the sum output of column B in the following format in a cell

111 23
121 33
151 55
sum=23+33+55

thanks in advance

Gokz