•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Excel formula for projected annual totals
Our take
Feeling stuck with your Excel formulas? You’re not alone! Many users want a straightforward way to project annual totals based on current performance. Imagine having a formula that takes a single cell value, like your January sales, and effortlessly predicts your year-end total. With the right formula, you can quickly calculate your “on-pace for the year” total—transforming your data into actionable insights. Let’s dive into how you can set this up and empower your spreadsheet skills!
Hi there, does anyone know how to make an Excel formula which takes a number found in one cell and then predicts, based on the current date, the "on-pace for the year" total that that cell might suggest? For example, if its January 31st and I have 10 sales, then the on-pace formula would take that "10" number and give me a total of 120 (10 x 12 months). I can't seem to figure it out. Thanks for any help you can provide!
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Auto-Updating Formula to reflect YTD percentageHey 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? submitted by /u/loozrrtuba [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]
- 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]
- Calculate the base sales forecast (baseline) for 12 months.I have a task: To calculate the base sales forecast (baseline) for 12 months. This is a task for demand planning. I have 200+ SKUs, a table in which there is a sales history for 2024, promotions that will be held in 2025, and 2026 is empty, for which it is necessary to calculate the basic sales forecast. Among the positions there are those that have a sales history for the whole of 2024 (some moonths have zero values, some do not), and positions that have high sales in the middle of the year (2 to 5 times higher than the neighboring months), and those with a sales history that begins in the middle of 2024, and before that they were not sold. This is the first time I've encountered such a task, so I need to understand how to do it, at least the basic algorithm, general idea. I tried cleaning the data using the median, removing zeros and spikes (if the value in the cell is greater than 1.5*median, then put the median), but I just don't understand what to do next? submitted by /u/CeroCell [link] [comments]