Thread: Empty cells with formulas
View Single Post
 
Old 02-01-2018, 05:30 PM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2010 32bit
Expert
  
Join Date: Apr 2014
Posts: 956
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
=COUNTBLANK(D1:D15)
also counts cells with formulae returning "" as empty.

This may not help depending on how you're wanting to act on the information.
Reply With Quote