•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Auto-Updating Formula to reflect YTD percentage
Our take
Hey Excel Gurus! I’m seeking your expertise to create a dynamic formula for my sales spreadsheet. I want to compare a rolling Year-to-Date (YTD) total in column B (2025) against the same period from last year in column C (2026). Specifically, I need a formula that updates automatically as I enter new monthly sales figures, reflecting the current YTD percentage. For instance, as of today, I want to see the percentage based on the data available so far. Is there a way to achieve this?
Hey Gang of Excel Gurus. Could not find the answer to this in search, probably because I don't know how to exactly describe the function I am looking for...
So I have a sales spreadsheet similar to the sample one attached here.
The question is how to create a formula to reflect a comparison sum that is a "rolling" total in column B (2025) so that I can compare as a Year to Date with Column C (2026).
In my example, I have sales numbers for this year, thus far. i want to know the percentage of what it was for the same period last year. I want the percentage to update so that when I eventually enter a value in for April, the sum for Jan-Apr in 2025 will update and thereby reflect the updated percentage in a different cell. Therefore: As of today the YTD percentage is....
Is there a way to do this? To have a formula update somehow when new data is entered in a different cell, or set of cells?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Dynamic YTD Formula from Pivot Table DataHi, I was tasked with creating a dynamic P&L statement from a trial balance query. The P&L statement is supposed to have a period selection tab(select period type(month, quarter) -> select period(june, q2, etc). I have to come up with a formula that calculates CY YTD and PY YTD and automatically updates whenever the selected period is changed. Does anyone have any idea as to how I can do this? And if there's any way to achieve this without the Pivot Table, thats also fine. I've been stuck for hours. https://preview.redd.it/qk83w0iifpxg1.png?width=1716&format=png&auto=webp&s=3e6d8be78665054293ecff77a0e659a6acbc254a https://preview.redd.it/dfa9x2iifpxg1.png?width=1378&format=png&auto=webp&s=ea6996e5648327ad13c9bb3da9339137da80e825 submitted by /u/Relative-Neck6922 [link] [comments]
- Monthly tracking workbook I use to track employee sales metrics; Trying to find a way to make the process less labour intensiveTruly having a hard to describing my issue effectively but hoping someone can help. First time posting here and I'm by no means an expert with excel, so please be kind! I have a monthly workbook where I track each employees revenue and other metrics. Every 2 weeks for payroll, I provide a print out of these numbers, and the payroll sheet pulls data from multiple sheets in the workbook. For example, every workbook has a separate sheet for each day of the month, titled "1" through "31". I have pay period sheets, so I'll use one titled "04.02.26 - 04.15.26". Then I'll have the data for each employee pulled from multiple sheets. For example, I use the formula =SUM('2:15'!E3) to pull the sales data from each day of that period for the specific employee. This works quite well. However, when I create a new month's spreadsheet, I have to manually alter this formula for each employee and for each data point (more than just revenue, at least 6 different data points for 7 employees). Is there a way to automate this? For example, a cell or two where I'm able to enter the date range and all of the formulas update to that date range for the corresponding pages? I'm sorry of this post is confusing. Truly it's confusing even typing it! submitted by /u/Ok_Smile9222 [link] [comments]
- Sum of a range based on 2 different criteria?Hello, I'm working on a document which is a holiday funds to keep track of individual person's remaining balance to pay. I want to use a formula to automatically calculate the sum of a range of cells which lie against a certain year under a person's name. Below as an example: https://preview.redd.it/1p19n1o8qrxg1.png?width=991&format=png&auto=webp&s=2e67c0337da92ae1feffe43fc2c7fbaba237d672 As above, I want to look up Name 1 in 1:1, look up Year 1 in A:A and then return the sum of those numbers in that Year 1 range to give me my final result. Is this possible? I've tried all sorts of SUM, SUMIF, SUMIFS, XLOOKUP and combinations but can't seem to get it to work. I also don't want to have to manually select the cells for year SUM as this is constantly updating and want it to be automated. Thank you! submitted by /u/celestialspace [link] [comments]
- Formula or function for tracking change over timeI am working on a spreadsheet that projects class need and usage over a 4 year period. The top row of my chart tracks how many students are able to enroll each month. I project these enrollments a year at a time then duplicate the numbers for the next 3 years (i.e January is 6, February is 0, March is 4, April is 2, May is 4 and so on). Students graduate in 5 months. This is tracked in the second line. So January enrollment of 6 and makes a May graduation 6. The third line tracks students in the program in any given month. So if there were 0 before January, and January had 6 enrollments line three would be 6 for January, 6 for February, 10 for March, 12 for April and May would be 10 (6 added/6 graduated). Is there a way to automate the calculation for the third line? I feel like this should be simple but I can’t quite figure it out. Editing for relevant info: I’m online, on a laptop using windows. I’m using Microsoft Office LTSC Professional Plus 2024. submitted by /u/Crazy_Stay4392 [link] [comments]
Tagged with
#Excel alternatives for data analysis#generative AI for data analysis#natural language processing for spreadsheets#AI formula generation techniques#formula generator#Excel compatibility#Excel alternatives#rows.com#big data management in spreadsheets#modern spreadsheet innovations#machine learning in spreadsheet applications#enterprise-level spreadsheet solutions#digital transformation in spreadsheet software#conversational data analysis#collaborative spreadsheet tools#AI-driven spreadsheet solutions#cloud-based spreadsheet applications#real-time data collaboration#financial modeling with spreadsheets#automation in spreadsheet workflows