Summing cells with different numbers of rows (large data sheet, HELP)

[bradydecouto]

Hello,

I have a large amount of data, and I need to figure out a formula to sum up only the values with specific numeric labels. Here's an example of the layout:

1 32
1 45
1 11
1 38
1 65
2 45
2 89
2 67
3 55
3 45
3 67
3 10

As you can see, each label in the first column has a different number of rows. How could I insert a formula to the right of this that would only sum the values next to 1's, 2's 3's, and so on?

Thanks,
B

[MrShorty]

A SUMIFS() function should be able to do that -- if a formula solution is required: https://support.office.com/en-us/art...6-611cebce642b

A pivot table would also do that, if you would prefer a pivot table approach: http://www.excel-easy.com/data-analy...ot-tables.html

[CK76]

I'd just use pivot table. But if that's not an option...

May be...
=IF(COUNTIF($A$2:A2,A2)=1,SUMIF(A:A,A2,B:B),"")

This will show total value for each number group at first appearance of that number.
0.JPG