Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a table, and I want to do a Vlookup on Column1, and when I find what I
am looking for, I want to sum column 2 from that row down to the bottom of the table. For example, Item 1 2345 Item 2 3478 Item 3 1298 Item 4 123 Item 5 1233 I want to find "Item 3" and then I want to be able to return the sum of (1298+123+1233). How would I do this? My thoughts were that I would do a lookup to get the row numner of "Item 3" and then do a sum() with the cell range starting from the row where I found "Item 3" but I'm not sure how to do that. Thanks, Steve |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
return the Cell address of a value | Excel Worksheet Functions | |||
vlookup for an unique Text and return its address? | Excel Discussion (Misc queries) | |||
USING VLOOKUP TO RETURN A CELL ADDRESS | Excel Worksheet Functions | |||
Return a cell address | Excel Worksheet Functions | |||
LOOKUP & RETURN CELL ADDRESS | Excel Worksheet Functions |