Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Nov 2007
    Posts
    65
    Thanks
    0
    Thanked 0 Times in 0 Posts

    count emppty or full cells (excel 2003)

    hi there
    if i have a table that runs A2 to H17 that doesnt have data in all the cells how do i count the full or empty cells in column G2 to G17?
    thanks kitty

  2. #2
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: count empty or full cells (excel 2003)

    You'll find the Lounge has a useful Search function! - see the link above.

    A quick search for "count empty cells" in the Excel forum brings up plenty of reading, including the thread beginning with <post:=669,367>post 669,367</post:>.

  3. #3
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: count emppty or full cells (excel 2003)

    Have a look at the functions in Excel help for

    COUNTBLANK
    COUNTA
    COUNT
    COUNTIF

    The syntax is in the help file and these should cover all your needs from the given question
    Jerry

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: count emppty or full cells (excel 2003)

    <pre>=COUNTBLANK(G2:G17)</pre>

    will give the number of blank/empty cells

    <pre>=COUNTA(G2:G17)</pre>

    will give the number of non-blank cells

    FYI,
    <pre>=COUNT(G2:G17)</pre>

    will give the number of cells with numeric entries in them

    Steve

  5. #5
    Star Lounger
    Join Date
    Nov 2007
    Posts
    65
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: count emppty or full cells (excel 2003)

    sorted many thanks

Posting Permissions

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