Took a look at your sheets, looks complex so not entirely sure which part it is you want looking at, that’s probably why no one has replied yet. Can you not do this:
Have a cell to enter start period, a cell for end period (e,g 1, 4) then a button that would calculate, if you can do a cut-down version with only what you need calculating i can make you up an example with some code.
![]() |
Patch reliability is unclear. Unless you have an immediate, pressing need to install a specific patch, don't do it. |
SIGN IN | Not a member? | REGISTER | PLUS MEMBERSHIP |
-
Got to be a better way. (Excel 2003)
Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » Got to be a better way. (Excel 2003)
- This topic has 2 replies, 3 voices, and was last updated 18 years, 7 months ago.
AuthorTopicWSNoirenex
AskWoody LoungerSeptember 30, 2006 at 4:21 pm #435781Viewing 0 reply threadsAuthorReplies-
WSmckim
AskWoody LoungerOctober 2, 2006 at 3:06 pm #1030955I am working with a fund return calculator that accounts for additions and subtractions to and from the fund over time. I would like to know what the return is for each period with out modifying the calculator for each time period. Example: I want the return for period 1, then period1-2, then period 1-3…..period 1-50. I am sure a macro could do all of those for me but I am sure a formula can be written to do it as well. I am stuck. Thanks.
I am sorry I was not more clear. The data I am working with is quarterly data that the calculator refers to. I am trying get a “running total” cumulative return. For example I have modified the formulas and cell references of the Portfolio Life Calculator tab and created the tab named Annual Calculator. The Annual Calculator gives the return for the first 4 periods (4 quarters) of the funds life which is 19.4%. I would next like to calculate the return for the first 5 periods (5 quarters) without having to copy the calculator and change the formulas, insert rows, change cell references, etc. I was hoping to get a formula that I could just copy down a column that would give me that running cumulative total return. Another thing that might eliminate confusion is the input labeled Number of Days in period should be labeled Number of Periods. Thanks.
-
WSsdckapr
AskWoody Lounger
-
Viewing 0 reply threads -

Plus Membership
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Get Plus!
Welcome to our unique respite from the madness.
It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.
Search Newsletters
Search Forums
View the Forum
Search for Topics
Recent Topics
-
search by picture an not all that’s cracked up to be (Awaiting moderation)
by
Dru Fuksa
1 hour, 32 minutes ago -
Google’s Veo3 video generator. Before you ask: yes, everything is AI here
by
Alex5723
8 hours, 37 minutes ago -
Flash Drive Eject Error for Still In Use
by
J9438
10 hours, 10 minutes ago -
Windows 11 Insider Preview build 27863 released to Canary
by
joep517
1 day, 3 hours ago -
Windows 11 Insider Preview build 26120.4161 (24H2) released to BETA
by
joep517
1 day, 3 hours ago -
AI model turns to blackmail when engineers try to take it offline
by
Cybertooth
7 hours, 9 minutes ago -
Migrate off MS365 to Apple Products
by
dmt_3904
7 hours, 58 minutes ago -
Login screen icon
by
CWBillow
3 hours, 8 minutes ago -
AI coming to everything
by
Susan Bradley
5 hours, 56 minutes ago -
Mozilla : Pocket shuts down July 8, 2025, Fakespot shuts down on July 1, 2025
by
Alex5723
1 day, 19 hours ago -
No Screen TurnOff???
by
CWBillow
1 day, 19 hours ago -
Identify a dynamic range to then be used in another formula
by
BigDaddy07
1 day, 20 hours ago -
InfoStealer Malware Data Breach Exposed 184 Million Logins and Passwords
by
Alex5723
2 days, 7 hours ago -
How well does your browser block trackers?
by
n0ads
1 day, 17 hours ago -
You can’t handle me
by
Susan Bradley
17 hours, 56 minutes ago -
Chrome Can Now Change Your Weak Passwords for You
by
Alex5723
1 day, 10 hours ago -
Microsoft: Over 394,000 Windows PCs infected by Lumma malware, affects Chrome..
by
Alex5723
2 days, 19 hours ago -
Signal vs Microsoft’s Recall ; By Default, Signal Doesn’t Recall
by
Alex5723
1 day, 22 hours ago -
Internet Archive : This is where all of The Internet is stored
by
Alex5723
2 days, 19 hours ago -
iPhone 7 Plus and the iPhone 8 on Vantage list
by
Alex5723
2 days, 19 hours ago -
Lumma malware takedown
by
EyesOnWindows
2 days, 7 hours ago -
“kill switches” found in Chinese made power inverters
by
Alex5723
3 days, 4 hours ago -
Windows 11 – InControl vs pausing Windows updates
by
Kathy Stevens
3 days, 4 hours ago -
Meet Gemini in Chrome
by
Alex5723
3 days, 8 hours ago -
DuckDuckGo’s Duck.ai added GPT-4o mini
by
Alex5723
3 days, 8 hours ago -
Trump signs Take It Down Act
by
Alex5723
3 days, 16 hours ago -
Do you have a maintenance window?
by
Susan Bradley
1 day, 21 hours ago -
Freshly discovered bug in OpenPGP.js undermines whole point of encrypted comms
by
Nibbled To Death By Ducks
2 days, 18 hours ago -
Cox Communications and Charter Communications to merge
by
not so anon
3 days, 19 hours ago -
Help with WD usb driver on Windows 11
by
Tex265
3 hours, 19 minutes ago
Recent blog posts
Key Links
Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.
Mastodon profile for DefConPatch
Mastodon profile for AskWoody
Home • About • FAQ • Posts & Privacy • Forums • My Account
Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts
Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.