On Mon, 29 Jun 2009 10:18:01 -0700, Shane Devenshire
wrote:


Hi,

If the data were contiguous one would use something like

=SUM(OFFSET(C1,COUNT(C:C)-1,,-12))

in your case try

=SUM(E22:E33,OFFSET($E$5,COUNT(E22:E33),,12-COUNT(E22:E33)))


This formula does unfortunately not work when December data comes.
When there is data in all of E22-E33 there is a #REF! error generated.

Lars-Åke