Excel Formula.

[unmlobo]

I have a three colum sheet that has accout numbers in one colum (A), dollars in another (B), and . Colum A may have the same account listed more then once. If this is the case, i need to add the numbers in colum B that corrospond with colum A. And put them in Colum C Any ideas? Thanks!

Colum A Colum B Colum C
1234 2 2
1345 2 6
1345 4
1567 2 2

 

[AnotherHiggins]

First, sort by column A.

Then, assuming you have headers in Row 1, place this formula in C2:
[COLOR=blue white]
=IF(A2=A1,"",SUMIF(A:A,A2,B:B))
[/color]

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[AnotherHiggins]

Oh yes, and fill the column down as far as needed.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.