| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do you Sum the range of two lookup values?
This is my lookup function. =LOOKUP("Next Accrual",A5:A25,C5:C25) I need a formula that will add the range from C5 to the point where this lookup function is satisfied. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do you Sum the range of two lookup values?
Hi
try: =SUM(OFFSET($C$5,0,0,MATCH("Next Accrual",A5:A25,0))) -- Regards Frank Kabel Frankfurt, Germany Sum the range of two lookup values? wrote: This is my lookup function. =LOOKUP("Next Accrual",A5:A25,C5:C25) I need a formula that will add the range from C5 to the point where this lookup function is satisfied. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup value that falls between two values in a range and then som | Excel Worksheet Functions | |||
| Lookup through a Range of Values in different cells | Excel Discussion (Misc queries) | |||
| Lookup and return range of values | Excel Worksheet Functions | |||
| Lookup within a range of values | Excel Discussion (Misc queries) | |||
| How do I use LOOKUP to return a range of values, then SUM values? | Excel Worksheet Functions | |||
Linear Mode
