Thread: SubTotal function counts the blank cells with formula
View Single Post
 
Old 12-28-2019, 12:58 PM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
  
Join Date: Apr 2014
Posts: 871
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
Quote:
Originally Posted by jeffreybrown View Post
How can the cells be blank if it has a formula?
formula:
=""
1. is counted as a blank by COUNTBLANK
2. is counted as not being blank by SUBTOTAL(103,… (aka COUNTA).
Reply With Quote