LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
inquirer
 
Posts: n/a
Default using functions empty cells

If I have a column of data that contains some empty cells, how can I use
the average or var functions and have them ignore the empty cells?

I have seen this before but can't find it now so I am hoping someone can
point me to the correct way
Thanks
Chris
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I remove hidden empty text cells from Excel? Bill Z1P Excel Worksheet Functions 2 October 2nd 05 08:04 PM
Copy empty cells from one workbook to another - Code Dave Peterson Excel Discussion (Misc queries) 1 September 23rd 05 02:10 PM
how do populate empty cells with the contents of populated cells . Jim99 Excel Discussion (Misc queries) 6 April 21st 05 05:44 PM
data in empty cells samsmimi Excel Worksheet Functions 3 April 1st 05 12:22 AM
Excal Concatination of cells that are not empty orourksj Excel Worksheet Functions 5 January 20th 05 09:51 PM


All times are GMT +1. The time now is 02:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"