Thread: COUNTA function returns incorrect value
View Single Post
 
Old 10-16-2012, 12:34 AM
macropod's Avatar
macropod macropod is online now Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,343
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
For testing the range F32:F34 or F37:F42, your COUNTA expression is wrong. It should be:
=COUNTA(F32:F34)
=COUNTA(F37:F42)
Now, whether COUNTA will report anything other than 2 for either range depends on what, if anything, the referenced cells contain.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote