Results 1 to 13 of 13

help with Countifs and array

Threaded View

  1. #1
    Registered User
    Join Date
    12-28-2018
    Location
    BC Canada
    MS-Off Ver
    MS Office 360
    Posts
    16

    help with Countifs and array

    Hi, newbie needing some help... (see attachment)

    I have 4 columns of data I need to use at the moment... I am looking to do the following:
    - if a row contains "999" or 101, 102, 104, 105, 107, or 108 in any of the 4 columns (F:I), I want the empty column tot he right to show "1"

    column H & I would be exactly those numbers, where F & G may contain something like xyz999

    Ive started a formula that will work for counting the 999, but cant get the rest... and not sure how to make it count as only "1" and not 3 if there are multiple 999/or 102... in the row
    Attached Images Attached Images
    Last edited by spenny32; 01-17-2019 at 06:24 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. COUNTIFS + Array?
    By ktennies in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-07-2018, 10:03 PM
  2. CountIFS With Array
    By jo15765 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-18-2017, 02:20 AM
  3. Countifs on an Array Range using multiple criteria in an Array
    By Mysore in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-12-2016, 04:39 PM
  4. COUNTIFS + OR (array tray) not working
    By Lugashz in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-14-2015, 10:52 AM
  5. VBA countifs within ARRAY
    By Kramxel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-19-2015, 04:41 AM
  6. [SOLVED] Array functions & COUNTIFS (or alternative f-n)
    By akamenov88 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-29-2015, 03:51 PM
  7. Countifs multiple criteria array
    By lamdl in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-20-2014, 09:18 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