Msi, judging by your screen shot it seems to me you want the SUMIF function. Look up the help info on it; I don't use it much, but the general idea is that it'll look at two columns, and wherever in one column the value matches your drop-down selection, it'll add up the values in the other column.