CountA function to Count Blanks

gebobs · #1 02-10-2015, 12:22 PM

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.

Alaska1 · #2 02-10-2015, 12:43 PM

Thank you. It worked when I did it in the sample. I got 120 this time. The only thing is I cannot use #this row because I have all my reporting on one worksheet. I want it to be able to total on a separate worksheet. If I use this row it has to be in the main document.

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