Ok, did what you suggested.......but am getting a 0 value....below is my
current list (it of course grows every day), starting in A1. Now, with A19
being blank, the formula should return 8.50, but it's returning 0.

6.00
13.83
22.33
22.33
0.00
8.50
17.00
17.00
0.00
8.50
17.00
25.50
33.50
42.00
42.00
0.00
8.50


Don

"Peo Sjoblom" wrote in message
...
It's this part

A1:A10=""

it's what is called an array formula, you can lookup array formula in help

http://www.cpearson.com/excel/ArrayFormulas.aspx


--


Regards,


Peo Sjoblom



"DW" wrote in message
...
Thanks everyone....

Now, this might be a dumb question, but why the ctrl+shift + enter combo
to commit the formula?


Don