Thanks Domenic this works great
"Domenic" wrote:
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
|