HLOOKUP : Can it sum up data?


Posted by CAS on August 23, 2001 8:43 AM

Can the HLOOKUP function also perform the sum function? Once the lookup has found my lookup value in my table I want it to sum the rows located below that value. ANY help is greatly needed and appreciated.
Thanks

Posted by cpod on August 23, 2001 11:15 AM

You can use a combination of functions for this. If your table is in A1:B20 (column A being the lookup column and B being the column you wish to sum) and your lookup value is in D1 then:

=SUM(OFFSET(A1,MATCH(D1,A1:A20,0),1,20,1))

will sum 20 rows of column B starting with the row below your lookup value.

Posted by Aladin Akyurek on August 23, 2001 11:16 AM


> Can the HLOOKUP function also perform the sum function?

No.

> Once the lookup has found my lookup value in my table I want it to sum the rows located below that value. ANY help is greatly needed and appreciated.

Care to post 10 rows of your data?

Aladin



Posted by CAS on August 23, 2001 12:52 PM

That works. Thanks alot!!

: Can the HLOOKUP function also perform the sum function? Once the lookup has found my lookup value in my table I want it to sum the rows located below that value. ANY help is greatly needed and appreciated. : Thanks