formula question, probably an easy one

bmw507

New Member
Joined
Oct 30, 2003
Messages
5
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
 

Some videos you may like

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
Joined
Mar 23, 2005
Messages
20,825
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
Joined
Feb 16, 2002
Messages
8,458
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)
 

Watch MrExcel Video

Forum statistics

Threads
1,118,820
Messages
5,574,511
Members
412,599
Latest member
Schu94
Top