I think I understand... So, for example, you want to add all the numbers in
Column B where Column A has "Choice 1" selected? Try this:

=SUMPRODUCT(--(A1:A1000="Choice 1"),B1:B1000)

Modify to meet your needs.

HTH
Elkar


"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!