year to date

I have this formula working on an older version of this report: COUNTIFS(Transactions[Year],B$2,Transactions[Mo No],"<="&MONTH(B$3&" 1")). I have copied and pasted it into a new but similar project: COUNTIFS(Table1[Year],C$3,Table1[Month],"<="&MONTH(C$4&"1")) I am getting back a 0 result...

Hi all, I have 12 months of data. The months are listed acrossed the top in columns J to U & accounts down the side in col A. I need a formula that will sum Jan-March but not include all 12 months. I’d be preparing the March report in April. Then in May I’d need it to know to pull Jan-April. I...

I'm new to this forum and very new to excel as well. There are some things I can do but this i need is over my head. I've gotten a template from the microsoft template site to use for my employees taxes etc to calculate and add into a paystub. The spreadsheet works wonderful and is just...

<tbody> Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total YTD Total YE Actual Actual Actual Actual Actual Actual Actual FCST FCST FCST FCST FCST YTD All pt1 10 10 10 10 15 15 15 20 20 20 30 30 85 205 pt2 pt3...

In E5-E16 I have data from one year. In Column H5-H16 I have the same data type for the next year. I want to see the year to date increase/decrease in percentage which for each month I have Calculated in Column "I" as =(H5-E5)/E5 and so on down through E16. I have data complete and in all...

Dear Fellow Excel Users, I need help with getting data externally from web and also keeping the previous data prior to the refresh. My external table/data has 10 rows reporting values per day (10 days data table). I can link the table to my sheet, however what I can not do is to create an...

Hi, I have the table below and I am trying to automate the YTD calculation. Does anyone have a suggestion for doing this? Thank you!!! Kt111 <TBODY> Jan 1 Feb 1 Mar 1 Qtr 1 3 Apr 1 May 1 Jun 1 Qtr 2 3 Jul 1 Aug 1 Sep 1 Qtr 3 3 Oct 1 Nov 1...

Hi, I have a pivot table that displays the sales per region month by month. For any given period I want to be able to compare the YTD sales figures with the YTD figures for the same period in the previous year. I have managed to create a second column displaying YTD sales next to the period...

I feel like this should be pretty straightforward using a Sum and Offset function. I have monthly revenue data in a table as follows: Excel 2010 <tbody> B C D E F G H I J K L M N O P Q 1 1/31/2012 2/29/2012 3/31/2012 4/30/2012 5/31/2012 6/30/2012 7/31/2012 8/31/2012 9/30/2012 10/31/2012...

So, I have a table that has the monthly sales in one column and the sales budgets in another column. Since monthly sales is a running total, it's easy to calculate current YTD. Sales Budgets is another thing entirely. We have Sales Budgets pre-written through December. What I need is to be...