Average percentage change
Solved
Meelania123
Posted messages
46
Status
Membre
-
Vaucluse Posted messages 27336 Registration date Status Contributeur Last intervention -
Vaucluse Posted messages 27336 Registration date Status Contributeur 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
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 réponse
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!
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!
Thank you thank you!
I'm marking the subject as resolved
safe travels
best regards