Growth formula

[Basavaraj K H]

I have some doubt,
(we need sum from cell D5 to O5(month on Month Data) and cell C5 we have value of full year data, i need to show the Growth %. .)

Exl file ls refer the attached file.

Please help me ASAP. .

Regrads
Basavaraju.

 

[SirJB7]

Hi, Basavaraj K H!
Your file doesn't match with the description. Could you check it and upload the fixed file including the expected value?
Regards!

 

[Somendra Misra]

Hi,

Check your uploaded file, the data ref. doesn't match with your problem description.

Regards,

 

[NARAYANK991]

Hi Basavaraj ,

The growth will be the difference between the sum of this year's 3 months ( first quarter ) , and the sum of the previous year's first quarter , divided by the sum of the previous year's first quarter.

Since you have a cumulative figure for the whole of the previous year , probably we can assume that one-fourth of this is the figure for the first quarter.

In this case , the growth comes out to be 25.9 %

See your file.

Narayan