month to date

I am hoping someone can help me with my formula to show rolling month to date data in a table. The problem with my current formula is that in the months with no data it is just carrying over the total from the previous month as you can see in the image attached. I want the cells from Jul - Mar...

Hello, Im hoping someone can help me with this. Not sure if my title is correct as to what i need… here is a description of what I'm trying to create: I have sales data for Months of January through December all in different columns. At the end of these months i have a column where i need to...

I have table that my managers update each week where they input numbers in for the following date ranges 1-7,1-14, 1-21, 1-28 1-31. The cell range is D7-H75. I do not want the sum In my MTD I just want the most up to date info.

Hello, I need to SUM sales for the current month, up to the current week. In cell A1 I store the current fiscal week. In B1 I store the current month. I've tried a lot of ways to accomplish this. Week to date and Year to date were easy enough, but I can't figure out how to dynamically define...

Hi All, I need some help on a calculation - I have a table full of data that I'm building a report on - This report will have Previous Day, Week To Date, and Month To Date calculation. How do I create calcs in the report so that it automatically pulls the Week to Date and Month to date calcs...

I am trying to figure out how to write a formula that will allow me to report LY MTD sales. The problem is that I have the entire drop of data for all of 2012 already dumped into the LY sales tab. I tried doing a sumifs function (as there are multiple attributes to be met in order to the get the...