Hi,
The result are in sheet2 and the information in Sheet1 so
in column A sheet2 starting in row1 enter the 6 four digit # and in B1 enter

Sumproduct(--(A1=sheet1!$A$1:$A$1000),sheet1!$B$1:$B$1000), then copy the
formula down and you will get the result for your 6 inputs

If you call your original sheet other than sheet1 just change the name in
the formula

"Japessebas" wrote:

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!