Try...

=SUMPRODUCT((A2:A10="Jim")*(B2:D10))

or

=SUM(INDEX(B2:D10,MATCH("Jim",A2:A10,0),0))

Hope this helps!

In article ,
ram wrote:

I would like help with the following problem:
I want to use the vlookup or sumif fucntion to find Jim and return the total
numbers of sales which would be 30 based on the table below. Is there any way
to have the sumif fuction sum by rows instead of columns?

Name Jan Feb Mar
Jim 10 10 10

Thanks for any help