Hi,
I have created the following formula to calculate the ratio of monthly growth rate of sales of Product A (in row 3) when the sales of Product B (in row 4) are growing, to the positive growth in sales of Product B:
{=((PRODUCT(IF($G$4:$AP$4>0,1+$G$3:$AP$3/100))^(1/COUNTIF($G$4:$AP$4,">0")))-1)/((PRODUCT(IF($G$4:$AP$4>0,1+$G$4:$AP$4/100))^(1/COUNTIF($G$4:$AP$4,">0")))-1)*100}
This formula works as required but can someone please tell me how to amend it to take into account a start and end date for the calculation is stated in cells A1 and B1, respectively?
Thanks!
I have created the following formula to calculate the ratio of monthly growth rate of sales of Product A (in row 3) when the sales of Product B (in row 4) are growing, to the positive growth in sales of Product B:
{=((PRODUCT(IF($G$4:$AP$4>0,1+$G$3:$AP$3/100))^(1/COUNTIF($G$4:$AP$4,">0")))-1)/((PRODUCT(IF($G$4:$AP$4>0,1+$G$4:$AP$4/100))^(1/COUNTIF($G$4:$AP$4,">0")))-1)*100}
This formula works as required but can someone please tell me how to amend it to take into account a start and end date for the calculation is stated in cells A1 and B1, respectively?
Thanks!