I should have mentioned that I am using excel 2000 and I wanted to have the
result come up on a second worksheet.

"Eduardo" wrote:

Hi,
I assume that the 6 choice imput are in column A and the numbers in column B
In column C enter the 6 inputs names starting in C1 and in D1 enter

Sumproduct(--(C1=A:A),B:B) copy formula down

If you are not using excel 2007 use the formula as follow

Sumproduct(--(C1=$A$1:$A$1000),$B$1:$B$1000)

If this was helpful please click yes. thanks

"Japessebas" wrote:

I have a worksheet with over 1000 entries. One column has a drop down menu
with a choice of 6 inputs, another column has different numbers on each row.
I would like to find a formula that will add the numbers for each of the 6
inputs.

If that makes sense!