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
.