View original (French)

Average percentage change

Solved
Meelania123 Posted messages 46 Status Member -  
Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   -
Hello,

I need help with an Excel calculation.
To summarize, I calculated the percentage changes in product sales by week for 2016 and 2017.
I noticed that there has been a decline in sales from a moment T, and this decline has continued up to today.
I would like to calculate an average of these percentage changes in order to present the average decline in sales from that moment T.

I hope I was clear,
I have attached an image of my table to make it clearer:


Thank you in advance,
Best regards,
M

1 answer

  1.
    Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
     
    Hello
    the problem with your table is that it contains texts in the week column instead of numeric values (unless week is displayed due to cell formatting?)

    Otherwise, it is easy to use (from Excel 2007):

    =AVERAGEIFS(D:D,A:A,">=Week No start",A:A,"<=Week No end")

    or if your limits are in cells:

    =AVERAGEIFS(D:D,A:A,">="&cell start",A:A,"<="&cell end)

    or if it's for an average from a minimum limit up to the last recorded %:

    =AVERAGEIF(A:A,">=Start No",D:D)

    best regards

    The quality of the response mainly depends on the clarity of the question, thank you!
    0
    1. Meelania123 Posted messages 46 Status Member 14
       
      Thank you very much, I modified the week column and indicated only the numbers (removing the texts). I used the first formula and I can see that the average percentage decrease is 45.

      Thank you thank you!
      0
    2. Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
       
      No problem
      I'm marking the subject as resolved
      safe travels
      best regards
      0