|
|
|
|
#1
10-16-2012, 12:34 AM
|
||||
|
||||
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] 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 How to release hard returns?
|
markg2 | Word | 13 | 05-08-2023 01:38 PM |
| IF formula returns wrong result | mashley | Excel | 3 | 09-07-2012 07:03 AM |
|
No tabbing, no returns in forms?
|
rdowney1 | Word | 7 | 06-29-2012 08:35 AM |
| IF formula returns TRUE instead of evaluating COUNTIF | ColinC | Excel | 4 | 12-28-2011 08:21 AM |
| Password is incorrect--but it's not. | orcasguy | Outlook | 2 | 11-10-2011 02:17 PM |
Windows 7 64bit 
Office 2010 32bit
Hybrid Mode