ytd

Excel masters, I need your help! I'm doing a monthly variance analysis and need a year-to-date formula that will calculate only columns that have monthly actuals populated in them. For example, I have 3 columns for each month (actuals/budget/variance) and a total year-to-date at the end...

Trying to Conditional format a Stacked graph for a YTD total. Sample data is below: <tbody> Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Target 506 476 491 495 501 489 508 503 519 487...

I have a stacked chart that needs conditional formatting dependent on YTD totals. Actuals under YTD Target are formatted Green and over YTD target are formatted Red. The Problem I'm having with the conditional formatting is when a YTD total crosses from Under to Over the Target (or Vice a...

https://imgur.com/a/LMZiMhH <------ Example image of the spreadsheet I use Each week I pull sales data and add to a report. On the top of the report, I have cell designated that the user can type in the week of the year, and the spreadsheet will update to reflect the data for that particular...

Hi all, I have an Excel file for the month end where I compare the data from this month to last year, for the actual month and year-to-date. When I open an earlier Excel file, certain links don't show the correct value anymore, I have to reopen the source file so that the correct value shows up...

Please see the file attached I want to input a formula in cell C5 which will sum data from C2 through to G2. If Mar is selected in C4 then cells C2 to E2 should be added https://drive.google.com/open?id=1g38lnSEv13xtBiWygeUWddjIRLmTPzLP The second argument of the sum function should be...

<colgroup><col span="24"><col><col><col><col></colgroup><tbody> I need to some help to sum the coloums from month to calulcate the Year to date, the problem is I have two type of columnes I need to sum </tbody> <colgroup><col...

Hi Everyone, I have a fact table that is filled with multiple departments, with multiple headcount types (full time, part time, contractors, etc), spanning several years, at the MONTH LEVEL. Some of the months during the year can have 0 values as well. I am trying to write a formula that...

Columns are Jan, Feb, Mar, Qtr1, Apr, May, Jun, Qtr2, etc. row 13 is a spread number row 25 is a volume number I'm calculating a YTD weighted average using volume as the weighting. I want the formula to return the year to date number based on the input in a certain cell. For example, if a...

Hello, I hope someone can help me to solve the problem i came across. Below is the table with repetitive values in Column B and $ values in column C. I need to make a table of TOP10 positive and negative impacts without using pivot table or helper column. I made the table using getpivotdata...

Trying to do a relatively simple SUMIFS formula, but getting a #VALUE ! error. I want to sum the weeks where YTD is on row 1: <tbody> YTD YTD Week 1 Week 2 Week 3 Total All COLORS 3827 3666 3997 11490 Total BLUE 0 0 6 6 Total GREEN 50 65 22 138 Total YELLOW 71 48 48 167 Total...

I currently have a scorecard and it has actual(to be entered per month) and plan(budgeted for the each month) for year. I am wanting to calculate a YTD sum for up to the current month only on the plan(budget) amounts. H4:S4 are the months (July to June) - I have hidden a column H3:S3 numbering...

Hey All! I work for a start-up company on the technical side of implant dentistry. Since there are so few of us in this company, I've taken it upon myself to help get us organized/track and make reports/etc so we can analyze, grow, and market. I've been watching youtube tutorials mostly over...

Hi all, I'm trying to group data based on volume. I'm grouping as follows:A: >2000 B: 1000-2000 C: 500-999 D: 100-499 E: 1-99 It looks like this: <tbody> Company FY 2017 YTD 2017 YTD 2018 Group ABC Company 40 12 12 E DEF Company 0 0 0 F GHI Company 2,489 1,136 945 A JKL Company 1,025...

Hi All, could anyone one please help me with a formula where my YTD formula should change automatically with a formula. for example: if the month is April once I input the month apr in an excel sheet the YTD Balance for pervious month should automatically sum the balances of Jan+Feb+Mar...

Hi all, I got below problem.. After I created a crosstab query pp, I could not create another query to calculate the YTD amount of ARPU. Does someone know what can I do? I confirm that my access has the right field for [pp].[Period]...

I wrote a pivot to add a new field to a pivot table but it's adding the field to the end of the other fields (Pivot has Month 1 - 8 and a YTD field) I want to add Month 9 so that I get Month 1 - 9 and a YTD field that adds up Months 1 to 9. When I record the Macro and place Month 9 where I want...

I wrote a pivot to add a new field to a pivot table but it's adding the field to the end of the other fields (Pivot has Month 1 - 8 and a YTD field) I want to add Month 9 so that I get Month 1 - 9 and a YTD field that adds up Months 1 to 9. When I record the Macro and place Month 9 where I want...

I have a macro to copy data from row B3 to the last row containing data in C3 on all sheets except specified sheets and all formulas to remain intact-see specified sheets not to be affected in code for eg Main Menu, YTD-Dashboard etc Row B3 onwards in being copied on some of the specified...

I am trying to write a macro that adds a new month of data to the Values section of a pivot table. Every month I need add the new month's data to the pivot report. My issue is I have a field called YTD that I need the new month's data to come before it. Currently the code put it after the YTD...