Results 1 to 4 of 4

Formel to count if not blank in a array, if another cell is equal to reference cell

Threaded View

  1. #1
    Registered User
    Join Date
    10-15-2014
    Location
    Copenhagen
    MS-Off Ver
    201, 2013, 365
    Posts
    42

    Formel to count if not blank in a array, if another cell is equal to reference cell

    Hi

    Hope you can help.

    I would like like to count if there is any activity, marked in any of the cells.

    Thinking something like

    If cells in array I21:I26, is not blank, count and type in "D" equals the corresponding C9-C19, type, then count the number of cells not blank.
    In the attached sheet I9 = 3, J9 = 1 etc...

    Hope this makes sense, I tried with if and counta but the logic is buggy me today.

    So reaching out.

    / Kristian
    Attached Images Attached Images
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 03-22-2021, 10:21 AM
  2. [SOLVED] Function to Get Array Count from Cell Reference and Repeat
    By desertshore in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-05-2015, 01:49 PM
  3. Replies: 5
    Last Post: 04-19-2014, 10:09 PM
  4. Replies: 3
    Last Post: 01-23-2014, 12:19 PM
  5. Replies: 1
    Last Post: 11-28-2013, 02:16 AM
  6. Replies: 2
    Last Post: 09-23-2013, 01:09 AM
  7. when is equal not equal - cell reference results to blank cell
    By riwiseuse in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-10-2009, 09:44 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