Will there *always* be 21 cells with numbers in them? If not, what should
happen?

--
Biff
Microsoft Excel MVP


"David" wrote in message
...
Hi

I am after the formula that will allow me to sum the values of the last 21
cells in a column that have a value. As some cells are blank, at times the
formula will have to count back more than 21 cells, sometimes only 21.

Is there a way other than manully changing the sum formula to increase the
range of cells covered whenever a blank cell occurs?

Thanks