View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mark Solesbury Mark Solesbury is offline
external usenet poster
 
Posts: 5
Default Count the blanks

Ive got a sheet, that is supposed to be fully filled in.

I would like a formula to count the number of blanks in each column.

If for example, the formula is in A100, id like it to show how many
cells have nothing in.


--
Mark

http://www.mozilla.com/firefox/ - Firefox Rules!
http://fireftp.mozdev.org/ - FTP Plugin for Firefox
http://ietab.mozdev.org/ - IE tab. Get Windows updates in Firefox