Count the blanks

[Mark Solesbury]

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

 

[Mark Solesbury]

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