Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2005
    Posts
    113

    Unanswered: Count rows and column

    Hey, can anybody help me? I would like to count how many rows and columns that has a value.

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Example, Column A contains the data you want to count.
    Now in column B put this formula:
    =iif(A1 = "",0,1)
    Apply all the way down the sheet and then sum at the bottom.

    Not the prettiest method by any means but it works and I can't think of a better one right now
    George
    Home | Blog

  3. #3
    Join Date
    Oct 2003
    Posts
    1,091
    Howdy. What do you mean by "value"? Any character, number, non-numerical?
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  4. #4
    Join Date
    Apr 2004
    Location
    Derbyshire, UK
    Posts
    789
    Provided Answers: 1
    Hi

    As shades pointed out, it can/will depend on what you define as a value, but COUNTA() and COUNTBLANK() functions may also be useful, perhaps with ISNUMBER() ??


    MTB

Posting Permissions

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