| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula?
I have a worksheet with a column for each year since 1998. In each column there are 52 rows showing each week's income for each year. I would like to have a cell above each of these columns showing Year To Date income for each year, comparable to the last completed week of 2006. For Example: In Column "A" starting in cell "A-7", we have the first week's income for the year 2006. There are 9 weeks worth of weekly income showing so far. In Column "B" will be identically the same, except "B" already has 52 weeks worth of income showing for year 2005. I want to make cell "A-3" show the year to date income for 2006. I want to have cell "B-3" show the year to date income for 2005 through the same week as in Column "A". Should show the YTD income through the 9th week for each column. Then so on across the page for years 2004-2003 etc. Is there a formula that I can use that will automatically advance each week to show the Year To Date amount in the past years? This will advance as each week of 2006 advances. Say next week will be an amount of YTD income for each year through the 10th week. I realize this is way too wordy, but I can't think of a way to shorten it and get my question across. -- lsmft ------------------------------------------------------------------------ lsmft's Profile: http://www.excelforum.com/member.php...o&userid=30678 View this thread: http://www.excelforum.com/showthread...hreadid=519941 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula?
in A3
=SUM(OFFSET(A$7,,,COUNT($A$7:$A$58))) and copy across -- HTH Bob Phillips (remove nothere from email address if mailing direct) "lsmft" wrote in message ... I have a worksheet with a column for each year since 1998. In each column there are 52 rows showing each week's income for each year. I would like to have a cell above each of these columns showing Year To Date income for each year, comparable to the last completed week of 2006. For Example: In Column "A" starting in cell "A-7", we have the first week's income for the year 2006. There are 9 weeks worth of weekly income showing so far. In Column "B" will be identically the same, except "B" already has 52 weeks worth of income showing for year 2005. I want to make cell "A-3" show the year to date income for 2006. I want to have cell "B-3" show the year to date income for 2005 through the same week as in Column "A". Should show the YTD income through the 9th week for each column. Then so on across the page for years 2004-2003 etc. Is there a formula that I can use that will automatically advance each week to show the Year To Date amount in the past years? This will advance as each week of 2006 advances. Say next week will be an amount of YTD income for each year through the 10th week. I realize this is way too wordy, but I can't think of a way to shorten it and get my question across. -- lsmft ------------------------------------------------------------------------ lsmft's Profile: http://www.excelforum.com/member.php...o&userid=30678 View this thread: http://www.excelforum.com/showthread...hreadid=519941 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula?
EXCELLENT !!!!!!!! Thanks Bob, that worked just fine for me. I owe you now!! Last year you helped me with one very similar to this too. Thanks again -- lsmft ------------------------------------------------------------------------ lsmft's Profile: http://www.excelforum.com/member.php...o&userid=30678 View this thread: http://www.excelforum.com/showthread...hreadid=519941 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula?
One a year, that's not too hard <vbg
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "lsmft" wrote in message ... EXCELLENT !!!!!!!! Thanks Bob, that worked just fine for me. I owe you now!! Last year you helped me with one very similar to this too. Thanks again -- lsmft ------------------------------------------------------------------------ lsmft's Profile: http://www.excelforum.com/member.php...o&userid=30678 View this thread: http://www.excelforum.com/showthread...hreadid=519941 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula?
Bob,
What means <vbg? Can I find a dictionary for abbreviations like that on the internet? Jack Sons The Netherlands "Bob Phillips" schreef in bericht ... One a year, that's not too hard <vbg -- HTH Bob Phillips (remove nothere from email address if mailing direct) "lsmft" wrote in message ... EXCELLENT !!!!!!!! Thanks Bob, that worked just fine for me. I owe you now!! Last year you helped me with one very similar to this too. Thanks again -- lsmft ------------------------------------------------------------------------ lsmft's Profile: http://www.excelforum.com/member.php...o&userid=30678 View this thread: http://www.excelforum.com/showthread...hreadid=519941 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula?
http://www.acronymfinder.com/
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "Jack Sons" wrote in message ... Bob, What means <vbg? Can I find a dictionary for abbreviations like that on the internet? Jack Sons The Netherlands "Bob Phillips" schreef in bericht ... One a year, that's not too hard <vbg -- HTH Bob Phillips (remove nothere from email address if mailing direct) "lsmft" wrote in message ... EXCELLENT !!!!!!!! Thanks Bob, that worked just fine for me. I owe you now!! Last year you helped me with one very similar to this too. Thanks again -- lsmft ------------------------------------------------------------------------ lsmft's Profile: http://www.excelforum.com/member.php...o&userid=30678 View this thread: http://www.excelforum.com/showthread...hreadid=519941 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula?
Very Big Grin.
http://www.sharpened.net/glossary/acronym.php?VBG Jack Sons wrote: Bob, What means <vbg? Can I find a dictionary for abbreviations like that on the internet? Jack Sons The Netherlands "Bob Phillips" schreef in bericht ... One a year, that's not too hard <vbg -- HTH Bob Phillips (remove nothere from email address if mailing direct) "lsmft" wrote in message ... EXCELLENT !!!!!!!! Thanks Bob, that worked just fine for me. I owe you now!! Last year you helped me with one very similar to this too. Thanks again -- lsmft ------------------------------------------------------------------------ lsmft's Profile: http://www.excelforum.com/member.php...o&userid=30678 View this thread: http://www.excelforum.com/showthread...hreadid=519941 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| 2 Nesting questions | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Linear Mode
