Quick Excel question

[Jakel]

I need a function that will add data in a column based on criteria in another column and then output it in the last cell in a 3rd column that meets the criteria. For example:

ID number blank column
1 25
1 15
1 45
1 50 SUM of all 1s HERE
2 10
2 15
2 10 SUM of all 2s HERE
3 5
3 6 SUM of all 3s HERE

 

[AnotherHiggins]

Let's say your data is in A2:B10 (assuming you have headers in Row1). Then you can put the following in C2:
[COLOR=blue white]=IF(A2=A3,"",SUMIF(A:A,A2,B:B))[/color]
and drag down as far as needed.

[tt]_____
[blue]-John[/blue][/tt]

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