View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Angela
 
Posts: n/a
Default Nesting-Don't use Blanks inside formula

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.