| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum of a named range with values based on vlookup results
see your other post
-- Biff Microsoft Excel MVP "Alibo" wrote in message ... From the answers you have given here I think you will e able to help me... I am trying to get the sum of multiple returns on a VLOOKUP. As an example: Jan 24 Jan 57 Jan 239 Feb 72 Mar 16 Mar 44 I want to get a result that looks like: Jan Feb Mar 320 72 60 I have tried: =SUMPRODUCT(VLOOKUP((Jan,A2:B7,2,FALSE)) But unfortunatley that just returns 24. Can you help? Alibo |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum values in columns based on values in named range | Excel Worksheet Functions | |||
| Q: Named range based on cell value? | Excel Discussion (Misc queries) | |||
| Referencing a named range based upon Range name entry in cell | Excel Worksheet Functions | |||
| inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) | |||
| Define a range based on another named range | Excel Worksheet Functions | |||
Hybrid Mode
