offset counter

[cpcKat]

I have 3 years of data organized
Q
Column
Row1 January
Row2 $
Row 3 $
Row 4 $


=sum(offset(Sheet1:Table 1::$Q$4,0,0,(COUNTA(Sheet1:Table 1::4:<wbr>4,"<>0")−12),1)
I am trying to do a rolling total for 12 months which does not include blanks or zeros, for my column Q, 4th row. Can you help me with the formula?

 

[jorismoerings]

Hi and Welcome to MrExcel,

Can you share some sample data and explain in somewhat more detail what your trying to accomplish.

As a helpful note: take notice of the https://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html
These guidelines holds valuable tips and tricks for posting questions.
They exist to help us to help you