On 24/03/2007 18:29, Mark Solesbury wrote:
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.


Ah...

It would seem that =COUNTBLANK does what i need to do.

Cock!

--
Mark
1996 90 300tdi
1987 RR V8 EFI

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