Hlookup to return a sum of values

[Abe]

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

 

[Domenic]

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!

 

[Jason Morin]

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

 

[CLR]

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