I hit send before I was done!

This array entered formula specifically excludes empty cells:

=STDEV(IF(A1:A5<"",A1:A5))

But it returns the exact same result as:

=STDEV(A1:A5)

Biff

"Biff" wrote in message
...
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.