+ Reply to Thread
Results 1 to 4 of 4

Count specific cells in a column

  1. #1
    Forum Contributor
    Join Date
    02-16-2006
    Posts
    200

    Count specific cells in a column

    My worksheet contains rows B19:B24.
    B19,B21,B23 contains formulas for picking up data from elsewhere in the workbook (the data can be text and numeric).
    B20,B22,B24 are blank and formatted for entering text

    I would like to count when data is input to cells B19,B21,B23 and ignore cells B20/22/24.
    I have tried to use CountA but it appears to be picking up the formulas in cells B19/21/23.

    What do I need to do?

  2. #2
    Valued Forum Contributor Shijesh Kumar's Avatar
    Join Date
    05-26-2008
    Location
    Bangalore / India
    MS-Off Ver
    2000
    Posts
    717
    Hi,

    If you can upload a sample sheet i would be able to get the solution faster

  3. #3
    Forum Contributor
    Join Date
    02-16-2006
    Posts
    200
    appears I have now worked it out - thanks anyway

  4. #4
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326
    Quote Originally Posted by martins
    appears I have now worked it out - thanks anyway
    Hi Martins,
    it would be nice if you could share your solution with the board !

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1