Formula Needed to calculate total totals in one column based on value in another...

I need a formula for the following scenario:

A1:A10 = single letter entries such as U or S
B1:B10 = number values entered : lets say each value is 200
C1 = formula

For this example, Lets say that A1 through A4 have the letter "U" and A5 through A10 have the letter "S"

I only want to calculate the totals (B1:B4) associated with "U" (A1:A4) into C1
As I change letters I want C1 to recalculate.

You will need an input cell to determine which letter values you want to calculate, so in C1 enter =SUMIF(A1:A10,D1, B1:B10), and in D1 enter the desired letter, such as "U". As you change the letter in D1, C1 will automatically recalculate.

Ha, make a post and there are already 2 of the same.

worked great, thx