CountA function to Count Blanks

		Microsoft Office Forums > Microsoft Excel > Excel
CountA function to Count Blanks

FAQ

Thread Tools

Display Modes

02-10-2015, 10:41 AM

Pecoflyer

Windows 7 64bit CountA function to Count Blanks

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,920

Pecoflyer has a reputation beyond repute

Try the COUNTBLANK function instead.

Define your range a s a Table to make it dynamic

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Counting Blanks in 1 Column and Non-Blanks in Another	dogwood705	Excel	4	02-07-2015 08:45 AM
Function to Count Data	bdavidson22	Excel	0	12-19-2014 11:48 AM
COUNTA function returns incorrect value	joeller	Excel	2	10-16-2012 05:37 AM
Use of MIN and count function together	khokababu	Excel	0	02-22-2012 09:40 AM
fill blanks in box	keevitaja	Word	1	05-23-2011 06:34 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:38 PM.