Thread: [Solved] CountA function to Count Blanks
View Single Post
 
Old 02-10-2015, 12:22 PM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
  
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default
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
File Type: xlsx Book1 (3).xlsx (30.9 KB, 12 views)
Reply With Quote