Try something like the following...

=SUM(HLOOKUP(LookupValue,A1:C10,{2,5,9},0))

....confirmed with CONTROL+SHIFT+ENTER. The numbers in the array
constant {2,5,9} determine which rows you wish to sum. You can change
or add to them as per your requirements.

Hope this helps!

In article ,
Abe wrote:

I am using the Hlookup function. However, rather then having it return a
single cell value, I want it to return a value equal to the sum of a number
of cells.

Please help.

Thanks