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