sumif function ??

[matmich]

Ok guys I am almost home with this.
I have a list of numbers how can I sum all the value for the a,b, an
c's. Will a sumif function work. Remeber I have already have the lis
so that only unique records for the letters appear, now i just need t
sum up all the like records
a 1
b 2
b 3
a 4
c 2
c 3
a 5
b

 

[Frank Kabel]

Hi
try
=SUMIF(A1:A100,"a",B1:B100)

you may replace "a" with a cell reference (from your unique list)

You may also consider using a pivot table on your sorece data whích
would create this kind of report automatically

 

[JulieD]

Hi

yes a sumif function will do what you want (well you actually need three
sumif functions)

Cell
C D
1 a =sumif(range with the a's in it,C1,range with the values
in it)
2 b =sumif(range with the b's in it,C2,range with the values
in it)
3 c =sumif(range with the c's in it, C3, range with the
values in it)

or you could just do
=sumif(range with the a's in it,"a",range with the values in it)
etc

or you might like to sort by letter (so all the a's are together etc) and
then use Data / Subtotals - group on the change in letter and sum the value
column (give your column's names first, like "letter" and "value")

Hope this helps
Cheers
JulieD