+ Reply to Thread
Results 1 to 3 of 3

Count how many cells in a row are NOT empty

  1. #1
    Forum Contributor
    Join Date
    05-10-2011
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    145

    Count how many cells in a row are NOT empty

    Please look at the file attached.
    billigarecept.se/file.zip (could not upload it to the message (tried several times..), so just download it from the link)

    I need macro that will do the following:
    Check if there are NON EMPTY cells on columns O to BD and write the results (how many non empty cells) in column N
    If the macro will work correctly, the results will look exactly like the few values i entered manually in column N.

    IMPORTANT: the amount of columns AFTER column N can be changed, sometimes it can be only 1 column (column O), sometimes 10 columns (column O to X) and sometimes 1000 columns... The macro should work with any amount of columns after column N

    Thanks,
    Sami

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,054

    Re: Count how many cells in a row are NOT empty

    You don't need macro.

    A formula will do it:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Never use Merged Cells in Excel

  3. #3
    Forum Contributor
    Join Date
    05-10-2011
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    145

    Re: Count how many cells in a row are NOT empty

    Exactly what i needed! thanks a lot!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula to count cells that are not empty excluding cells with formulas
    By Imbizile in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-20-2015, 07:08 AM
  2. Replies: 10
    Last Post: 09-26-2015, 08:26 PM
  3. Find count of filled cells and empty cells in a column
    By thepinkgeologist in forum Excel General
    Replies: 4
    Last Post: 09-22-2015, 01:03 PM
  4. Replies: 2
    Last Post: 07-25-2013, 01:01 PM
  5. How to count non-empty cells?
    By ljCharlie in forum Excel General
    Replies: 8
    Last Post: 03-30-2009, 10:23 AM
  6. count for empty cells
    By tikchye_oldLearner57 in forum Excel General
    Replies: 6
    Last Post: 05-25-2006, 03:45 PM

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