+ Reply to Thread
Results 1 to 2 of 2

Count no. of instance of value appear based on date in a tab where the col position vary

  1. #1
    Registered User
    Join Date
    03-23-2022
    Location
    Dublin, Ireland
    MS-Off Ver
    2016
    Posts
    1

    Count no. of instance of value appear based on date in a tab where the col position vary

    Hi
    I am looking for some help. I am looking to count the number of passed test cases per day which I currently use CountIFS formula.
    =COUNTIFS(Runs!$I:$I,C2,Runs!$E:$E,"Passed") where 'Runs' is the data source and C2 is date value.
    However my data source has changed where I have no control over column location of the 'Date' and (test case) 'Status' field will be located.
    I am seeking help in providing an excel formula to solve my probelm.

    Many thanks
    Jim

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Count no. of instance of value appear based on date in a tab where the col position va

    Hello Jiact43 and welcome to the forum.

    We will need more specific context. A small representative sample Excel workbook almost always helps. Please see the instructions at the top of the page in the 'gold' banner.
    Dave

+ 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. Count Based on First Instance and Criteria
    By Barieq in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-06-2021, 12:05 PM
  2. [SOLVED] first instance time based on date column
    By moneypennie21 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-20-2019, 06:04 AM
  3. Inputting a number based on position and skipping to next date
    By maym in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-25-2017, 02:42 AM
  4. [SOLVED] VBA to create a chart when data can vary in column position and rows
    By MalibuLX3 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 08-21-2013, 11:21 AM
  5. Replies: 3
    Last Post: 01-18-2013, 08:44 PM
  6. Locating Column Position Based on Date
    By yunesm in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-14-2011, 09:13 AM
  7. Sum of columns that vary in position
    By gibsol in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-17-2006, 10:55 AM

Tags for this Thread

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