Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count the blanks
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Non-Blanks in one column based on criteria in another | Excel Worksheet Functions | |||
Count IF excluding blanks or zeroes | Excel Worksheet Functions | |||
Count blanks cells | New Users to Excel | |||
Count Blanks in a Filtered Column | Excel Worksheet Functions | |||
Paste Special Skip Blanks not skipping blanks, but overwriting... | Excel Discussion (Misc queries) |