CountA function to Count Blanks

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

FAQ

Thread Tools

Display Modes

02-10-2015, 12:22 PM

gebobs

Windows 7 64bit CountA function to Count Blanks

Office 2010 64bit

Expert

Join Date: Mar 2014

Location: Atlanta

Posts: 837

There must be some mistake. When I use that formula, I get 120.

I checked this with the formula:
=IF(COUNTBLANK(Table1[@[Theme1]:[Theme3]])=3,1,0)

The file is attached.

Attached Files

Book1 (3).xlsx (30.9 KB, 12 views)

« 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.