Hi!

Empty cells and cells that contain text are ignored.

You don't need to specifically exclude empty cells.

Biff

"Angela" wrote in message
...
Hi. I am currently using the STDEV formula. Is there a way, that i can
make
the formula use data from nonblank cells, only. For example: A1, A2, A5
will
have numbers listed. A3 & A4 are blank. Can i get the formula to use
only
A1, A2, & A5?
Any help would be greatly appreciated.