Thread: [Solved] Getting the Count formula to count all rows
View Single Post
 
Old 08-22-2016, 11:18 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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
There is no Word field formula to do that for columns containing a mix of numbered cells with empty cells or cells containing text instead of numbers. If you have at least one fully-populated or one completely empty column (insofar as numbers are concerned in either case), you could use a formula like:
{=MAX(COUNT(ABOVE)-1,COUNT(LEFT),COUNT(RIGHT))}
Another workaround might be to insert an empty column (which you can come close to hiding) and count it's rows.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote