I see a couple things wrong with your formula as posted but might be
typos or just the way you copied it.

Try this based on Don's formula edited.

=SUM(INDIRECT("AY"&LARGE(IF(ISBLANK(AY19:AY10000), 0,ROW(19:10000)),4)):AY10000)



Gord


On Mon, 27 Feb 2012 19:38:15 +0000, puck1263
wrote:


So, I looked at this again and must have copied something wrong.

Now I get the #NAME? error all the way down the column.

Here is what I have in the first cell (row 19)
SUM(INDIRECT("AY"&LARGE(IF(ISBLANK(AY19:AY1000),0 ,RO
AY(19:1000)),4)):AY1000)


+-------------------------------------------------------------------+
+-------------------------------------------------------------------+