Addition of Cells dependent on drop down list in another column

Hi,

I've got a spreadsheet that has a column of numbers in it with a corresponding column that has a drop down list which has 4 names in it. So I put in a number associated with a name from drop list

I want to get a total number for each of the 4 people specified in the drop down list in another 4 cells. I can total all the cells in the column no problems but not sure what formula will give me a total for each person in another cell corresponding to their name and the number of rows they are selected in for the column of figures.

any help appreciated

TIA

can you upload an example please?

Originally Posted by DonkeyOte

See the SUMIF function in XL Help, ie assuming:

Column A holds names
Column B holds values

C1 to C4 holds the 4 names

D1: =SUMIF(A:A,C1,B:B)
copy down to D4

(may also be worth investigating Pivot Tables...)

I tried that in F19 but didn't work. I've uploaded a sample which will better explain what I'm trying to do.

TIA zbor & DonkeyOte

Originally Posted by DonkeyOte

Your summation column is incorrect - there are no values to sum in Column A.

It would make sense to use the headers in your table to define the criteria - in this case it then makes sense to link the headers to the source of the Validation List... ie:

F18: =INDEX($G$6:$G$15,COLUMNS($F18:F18))
copy across to I18

F19: =SUMIF($D:$D,F$18,$B:$B)
copy across to I19

DonkeyOte (geezer )
Many thanks from downunder