Dynamic fomula for Month, Qtr and YTD

This is what I have so far.

For the months array enter this formula in B2 an fill across.

Formula:

=INDEX($B$9:$S$12,MATCH($A$1,$A$9:$A$12,0),SMALL(IF(B$1=$B$8:$S$8,COLUMN($B:$S)-MIN(COLUMN($B:$S))+1),MONTH($A2&0)))

If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.

For quarters array entered in B3 and fill across.

Formula:

=SUM(N(INDEX($B$9:$S$12,MATCH($A$1,$A$9:$A$12,0),N(IF(1,SMALL(IF(B$1=$B$8:$S$8,COLUMN(INDEX(1:1,MATCH($A3,$B$6:$S$6,0)):INDEX(1:1,(MATCH($A3,$B$6:$S$6,0)+17)))),{1,2,3}))))))

The YTD I haven't done, yet.