Results 1 to 7 of 7

counting range of cells with condition

Threaded View

  1. #1
    Registered User
    Join Date
    03-14-2014
    Location
    Indiana, U.S.A.
    MS-Off Ver
    Excel 2010
    Posts
    6

    counting range of cells with condition

    are the apostrophe's what is meant by 'tags' when posting code? I want to make sure I submit a request for assistance accurately... But, what I got is, I need to count the number of cells populated across a range, but not the adjacent cell if it's populated... hard to explain.

    so, range of cells: c6, c7, c8, c9, c10, c11, c12, c13, c14
    8 4 8 8 4 8
    would only count as 3, since the adjacent cell has a value in it. Does that make sense? It is to track occurrences regarding absences; the frequency a technician calls in sick.

    ',    Range("C6:NE6").Select
    ',    Range("NG6").Activate
    ',    ActiveCell.FormulaR1C1 = "=COUNT(RC[-368]:RC[-2])"
    Thanks in advance with any assistance you are able to provide
    Last edited by blexor; 03-25-2014 at 03:59 PM. Reason: added 'code' tags

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. counting blank cells in range based on condition using another column
    By TheBlueBell in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-14-2013, 04:58 PM
  2. Counting the number of empty cells based on a condition in a range
    By naga in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-01-2013, 10:01 AM
  3. [SOLVED] Counting cells that fall in a date range AND meet a Yes/No condition
    By pentatonic145 in forum Excel General
    Replies: 2
    Last Post: 05-01-2012, 04:26 PM
  4. Replies: 2
    Last Post: 06-19-2006, 09:10 AM
  5. In excel counting cells in a range which meet condition ">Xand<X"
    By Uncivil Servant in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-19-2006, 09:45 AM

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