SUMPRODUCT Help

[Guest]

I need help with the following senario:
I have one row with names and the row below it contains numbers, I need to
be able to search the first row for the name each time it shows up then tally
the number that is below the name. For example, Jane Smith is entered in 3
columns and below her name in each column is a number (2,1,4) so I need to
come up with a total of 7.

Thanks,
Karen

 

[RagDyeR]

Names in Row1,
Values in Row2:

=SUMIF(1:1,"Jane Smith",2:2)

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

I need help with the following senario:
I have one row with names and the row below it contains numbers, I need to
be able to search the first row for the name each time it shows up then
tally
the number that is below the name. For example, Jane Smith is entered in 3
columns and below her name in each column is a number (2,1,4) so I need to
come up with a total of 7.

Thanks,
Karen

 

[Guest]

Worked perfect! Thanks so much.

 

[RagDyer]

You're welcome, and thank you for the feed-back.