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

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

Use SUMIF. For example, to sum row 1 where row 2
= "apple":

=SUMIF(2:2,"apple",1:1)

To learn more, see:

http://www.techonthenet.com/excel/formulas/sumif.htm

HTH
Jason
Atlanta, GA

-----Original Message-----
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
.

You can just put the formula =SUM(A1:A5), for example, in the cells in the
HLOOKUP table in place of numbers that would ordinarily display...........

Vaya con Dios,
Chuck, CABGx3



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