Results 1 to 5 of 5
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,924
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi

    Can anyone tell me where I can find any info on the countbelow function in word 2007. I have googled it but with no luck.

    Many regards

    Braddy
    If you are a fool at forty, you will always be a fool

  2. Subscribe to our Windows Secrets Newsletter - It's Free!

    Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts
    Can you explain a bit more about where you have found this "function", as I cannot find it anywhere obvious in the Word 2007 user interface.

  4. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,924
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by StuartR View Post
    Can you explain a bit more about where you have found this "function", as I cannot find it anywhere obvious in the Word 2007 user interface.
    Hi

    I can't swear to it but I think it was Hans V it goes something like {=(countbelow)} or {=(countabove)}

    Regards

    Braddy

    NB it appears if you use Ctrl and F9) and enter the formula it works but cannot see the formula again once you hit F9 again
    If you are a fool at forty, you will always be a fool

  5. #4
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,924
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by StuartR View Post
    Can you explain a bit more about where you have found this "function", as I cannot find it anywhere obvious in the Word 2007 user interface.
    Hi Stuart

    It was Pam Caswell not Hans V and the correct function is { =count(above) } or { =count(above)-1 } minus how many rows you do not want to count.
    or{ =count(below)-1 }
    Regards

    Braddy77

    Apologies to Pam and Hans.
    If you are a fool at forty, you will always be a fool

  6. #5
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    3,813
    Thanks
    0
    Thanked 166 Times in 153 Posts
    hi braddy,

    For info on using the ABOVE, BELOW, LEFT and RIGHT parameters as arguments for the AVERAGE(), COUNT(), MAX(), MIN(), PRODUCT(), and SUM() functions, check out 'Referencing Adjacent Cells In A Row Or Column' in my Word Field Maths Tutorial.
    Cheers,

    Paul Edstein
    [MS MVP - Word]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •