two columns of data, one with numbers, one with names, need a formula

[garrettw731]

I am trying to create a formula to count two columns of data. One column has names the, other has numbers. I want the formula to count the numbers only if they are in the same row as the specific name. How do I do this?

[grizzly6969]

A little more information would help but if column B has your names and column C has your numbers
in D [QUOTE][=SUMPRODUCT(--(B$2:B$100="shoes"),(C$2:C$100))/QUOTE]
or

=SUMPRODUCT(--(B$2:B$100=D2),(C$2:C$100))

were D2 is were you enter the name or use a dropdown

[arthurbr]

Maybe a plain SUMIF would suffice

=sumif(b2:b100,"shoes",c2:c100) - adapt ranges and conditions to your need

Grizzly

As OP seems to be using 2007, SUMIFS can be used instead of SUMPRODUCT

[grizzly6969]

thanks arthur I didnt know that

[arthurbr]

Garrett,
did you mean counting or summing?