Assuming your names are in column A, use an array formula like

=SUM(OFFSET(A1,MATCH("Jim",A1:A10,0)-1,0,1,3))

Change the final '3' in the formula to the number of columns you
want to sum.

Since this is an array formula, you must press Ctrl+Shift+Enter
rather than just Enter when you first enter the formula and
whenever you edit it later. If you do this properly, Excel will
display the formula enclosed in curly braces {}.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"ram" wrote in message
...
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