Addition of Cells dependent on drop down list in another column

**DonkeyOte** · 05-27-2009, 05:32 AM

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...)

**armitage** · 05-28-2009, 01:00 AM

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

**DonkeyOte** · 05-28-2009, 02:33 AM

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

**armitage** · 05-29-2009, 04:06 AM

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