Results 1 to 13 of 13

Countif with data validation

Threaded View

  1. #1
    Registered User
    Join Date
    12-11-2020
    Location
    Amsterdam, Netherlands
    MS-Off Ver
    2013
    Posts
    37

    Countif with data validation

    Hello all, Happy new year.

    This one has proved to be quite the challenge for me:

    Opening the workbook attached, you will see 3 sheets, Grid model, Dates for month and Interruptions.


    The grid model contains all the values to be counted on a daily basis, the Dates for month is the data validation sheet for ('Interruptions' cell F1) which allows results on the interruption sheet change when a different date is picked form the drop down list.

    I want to replicate cell F1 in Cell O1 with a different count criteria such that whenever an instance occurs (EF, OC, IMB, EMG, etc...) it's counted as 1 value. The values in Cells O4 - V4 and below are all correct for the 1ST of December, however these are manually counted results and I would like a formula that could do this instantly and not just for 1 day but for the entire month.
    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. Countif data validation
    By UltimateNeo in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-29-2019, 01:57 AM
  2. how does this COUNTIF formula work for Data Validation?
    By srush in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-30-2018, 07:25 AM
  3. [SOLVED] Nested COUNTIF / IF formula for data validation workaround
    By HeyInKy in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-03-2017, 02:33 PM
  4. COUNTIF based on Data Validation dropdown choice
    By EPosejpal in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-13-2017, 03:44 PM
  5. [SOLVED] Data Validation with CountIF?
    By bmasella in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-18-2014, 06:07 PM
  6. Replies: 4
    Last Post: 12-16-2013, 06:09 AM
  7. Replies: 3
    Last Post: 10-18-2010, 11:09 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