Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup / sumif (maybe....) query....
This may be a fairly easyone but basically i need a formula to look to see if
a specific cell value is in a vertical list of values on another spreadsheet (hence why i thought maybe a vlookup?), if it is i want it to sum a set number of the neighbouring horitontal cells, although the numbers of coloumns i want it to sum will vary each month as i move through the year (ie finding the YTD value), but always staying within the same row. I have tried a variety of vlookups and/or sumif combinations but just can get it to work, so i would be grateful if anyone can help........... |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup / sumif (maybe....) query....
Heidei,
The general idea of the equation would be along the lines of =SUM(OFFSET(SheetName!$1:$65536,MATCH("Specific Value",SheetName!$A:$A,FALSE)-1,1,1,MONTH(TODAY()))) Not sure when you say spreadsheet whether you mean a different sheet within the file, or a different file. HTH, Bernie MS Excel MVP "Heidi" wrote in message ... This may be a fairly easyone but basically i need a formula to look to see if a specific cell value is in a vertical list of values on another spreadsheet (hence why i thought maybe a vlookup?), if it is i want it to sum a set number of the neighbouring horitontal cells, although the numbers of coloumns i want it to sum will vary each month as i move through the year (ie finding the YTD value), but always staying within the same row. I have tried a variety of vlookups and/or sumif combinations but just can get it to work, so i would be grateful if anyone can help........... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF help and another query | New Users to Excel | |||
Sumif query | Excel Worksheet Functions | |||
sumif query | Excel Worksheet Functions | |||
Sumif Query | Excel Discussion (Misc queries) | |||
SumIf query ... | Excel Worksheet Functions |