Saturday, 15 March 2014

Excel formula to calculate YTD metrics by detecting current month -


My two excellent tables - 2015 sale and sale of 2014 are in the following format and the third category of one year The variance has been called on, it looks like a change from 2014 to 2015.

  2015 Feb Mar .... YTD (Total) Order Revenue ... ... January 2014 Feb Mar .... YTD (Total) Order Revenue ... ... Vicharan Jan Feb Mar .... YTD Order Revenue ... ...  

Computing the mass deviation is more than January or February Virien is easier than February. How do I calculate deviation of the date of the year? Since the 2014 table is already populated for the whole year - hence the last column is the sum of 12 months of data.

For 2015, I only have January and February. Therefore, there should be Vicharan Pillar for the year-by-year (January + February 2015) / (January + February 2014) How do I write a formula to examine the current month and after that only for those two months Do yoga

By using the Excel formula (no-VBA), you can calculate deviation for SUM , OFFSET , and COUNT functions. In the simple formula below, the line 1 is populated completely all 12 months. Line 2 has population for only 2 months. Using the COUNT formula in the category, OFFSET will extend the width based on the number of rows in the population.

Let me know if you have any problem in being friendly to it.

  = SUM (OFFSET ($ A $ 2,0,0,1, COUNT ($ A $ 2: $ L $ 2)) / SM (OFFSET ($ A $ 1, 0,0,1, COUNT ($ A $ 2: $ L $ 2)))  

No comments:

Post a Comment