# formula question, probably an easy one

#### bmw507

##### New Member
I have some data i would like to sum.

items,value,totals
abc,5
abc,10,15
def,15
def,20
def,25,60
ghi,5
ghi,10
ghi,15
ghi,20,60

I need help with a formula that will sum the totals at the end of the equal items as shown above...Please help...Jeff

### Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

#### barry houdini

##### MrExcel MVP
Here's one way....
Book1
ABCD
1abc5
2abc1015
3def15
4def20
5def2560
6ghi5
7ghi10
8ghi15
9ghi2050
10
Sheet1

Formula in C1 copied down column

=IF(A1=A2,"",SUMIF(\$A\$1:\$A\$9,A1,\$B\$1:\$B\$9))

#### Brian from Maui

##### MrExcel MVP
bmw507 said:
I have some data i would like to sum.

items,value,totals
abc,5
abc,10,15
def,15
def,20
def,25,60
ghi,5
ghi,10
ghi,15
ghi,20,60

I need help with a formula that will sum the totals at the end of the equal items as shown above...Please help...Jeff

On the surface it appears as,

=SUMIF(CriteriaRange,Criteria,RangeToSum)

Replies
1
Views
74
Replies
7
Views
86
Replies
1
Views
174
Replies
4
Views
381
Replies
5
Views
305