Formula to caculate Quarter on Quarter % from monthly data

[tonywatsonhelp]

Hi Everyone
I need a formula to calculate the quarter on quarter % from a grid of data in months?

Table below shows:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[TD]G
[/TD]
[TD]H
[/TD]
[TD]I
[/TD]
[TD]J
[/TD]
[TD]K
[/TD]
[TD]L
[/TD]
[TD]M
[/TD]
[TD]N
[/TD]
[TD]O
[/TD]
[TD]P
[/TD]
[TD]Q
[/TD]
[TD]R
[/TD]
[TD]S
[/TD]
[/TR]
[TR]
[TD]1C[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1/01/18
[/TD]
[TD]1/02/18
[/TD]
[TD]1/03/18
[/TD]
[TD]1/04/18
[/TD]
[TD]1/05/18
[/TD]
[TD]1/06/18
[/TD]
[TD]1/07/18
[/TD]
[TD]1/08/18
[/TD]
[TD]1/09/18
[/TD]
[TD]1/10/18
[/TD]
[TD]1/11/18
[/TD]
[TD]1/12/18
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]Current Month
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Quarter1
[/TD]
[TD][/TD]
[TD][/TD]
[TD]Quarter2
[/TD]
[TD][/TD]
[TD][/TD]
[TD]Quarter3
[/TD]
[TD][/TD]
[TD][/TD]
[TD]Quarter4
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]1/05/18
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]Quarter on Quarter Result
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]amounts along row 5
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]sum(H5+I5+J5/E5+F5+G5)
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]10
[/TD]
[TD]20
[/TD]
[TD]30
[/TD]
[TD]15
[/TD]
[TD]25
[/TD]
[TD]35
[/TD]
[TD]11
[/TD]
[TD]22
[/TD]
[TD]33
[/TD]
[TD]21
[/TD]
[TD]32
[/TD]
[TD]43
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD]above is the sum i need but for whichever quarter current month is in.
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Declamatory]

What would your formula be if the current month was 1/11/18?

 

[Declamatory]

OK so if the formula is always the same i.e. The current quarter divided the previous quarter then I would do the following.

First name the following ranges E5:G5 Quarter1, H5:J5 Quarter2, K5:M5 Quarter3 and N5:P5 Quarter4

in Cell A1 insert the following formula

=IF(OR(A3=E1,A3=F1,A3=G1),E2,IF(OR(A3=H1,A3=I1,A3=J1),H2,IF(OR(A3=K1,A3=L1,A3=M1),K2,N2)))

Then in Cell A5 insert the following formula

=IF(A1=E2,SUM(Quarter1),IF(A1=H2,SUM(Quarter2)/SUM(Quarter1),IF(A1=K2,SUM(Quarter3)/SUM(Quarter2),SUM(Quarter4)/SUM(Quarter3))))