|
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 |
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 |
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 |
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 |
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 |
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 |
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 |
| All times are GMT +1. The time now is 09:50 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com