How to use a letter in one column to add a value to another cell

[NUFF]

Hi all
I am new to Excel and I need to perform the at task


-I have the letters of the alphabet in column -A
-I have values in column B
-Each row has a letter with a corresponding value in column B
I would like to add all the individual values relent to the letter in column A to a new cell.
I would like to add all the individual values relent to the letter in column B to another cell.
this would mean that all the values linked to the individual letters in column A are added together.
for instants if I had 3 letter d in column A their corresponding values in column B will added together in another cell.

can any one help?

Nuff

[mehmetcik]

Use the SUMIF function.

If A1 to B8 is your Data

And D1 contains A

Then this if the formula to use:-

Please Login or Register  to view this content.

[FDibbins]

Dont need the "="& part there

=SUMIF($A$1:$A$8,$D1,$B$1:$B$8)