+ Reply to Thread
Results 1 to 3 of 3

Countifs if criteria is based on columns and rows (by date)

  1. 03-25-2021, 02:04 AM #1
    kingripper
    kingripper is offline
    Registered User
    Join Date
    03-02-2020
    Location
    Mexico
    MS-Off Ver
    MS 365
    Posts
    62

    Countifs if criteria is based on columns and rows (by date)

    Experts,

    I need your help, I want to use countifs with criteria based on column range and a criteria based on rows range which is by date. The criteria based on the rows is the current date. Please see my attached sample for more details. thank you in advance.
    Attached Files Attached Files
    Last edited by kingripper; 03-25-2021 at 03:30 AM.
    Reply With QuoteRegister To Reply
  2. 03-25-2021, 02:21 AM #2
    bebo021999
    bebo021999 is offline
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,466

    Re: Countifs if criteria is based on columns and rows (by date)

    S4:

    =IFERROR(1/(1/SUMPRODUCT(($A$6:$A$22=$R4)*($C$5:$M$5=$V$1)*($C$6:$M$22=S$3))),"")

    Drag down and accross
    Quang PT
    Reply With QuoteRegister To Reply
  3. 03-25-2021, 03:28 AM #3
    kingripper
    kingripper is offline
    Registered User
    Join Date
    03-02-2020
    Location
    Mexico
    MS-Off Ver
    MS 365
    Posts
    62

    Re: Countifs if criteria is based on columns and rows (by date)

    Quote Originally Posted by bebo021999 View Post
    S4:

    =IFERROR(1/(1/SUMPRODUCT(($A$6:$A$22=$R4)*($C$5:$M$5=$V$1)*($C$6:$M$22=S$3))),"")

    Drag down and accross
    Many thanks bro.. it works like a charm...
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] COUNTIFS based on multiple criteria that tracks changes in two columns
    By 27POP27 in forum Excel General
    Replies: 28
    Last Post: 05-28-2019, 08:17 AM
  2. Macro. Number of rows in column that meet 2 criteria in other 2 columns. Use of "CountIfs"
    By lcgar in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-06-2017, 10:14 AM
  3. Copy selected columns from rows one one sheet to another based on a date criteria...
    By bmasella in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-09-2017, 11:07 PM
  4. [SOLVED] Need to use either COUNTIFS or SUMPRODUCT to count rows based on multiple criteria
    By erabinov in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-15-2013, 03:15 PM
  5. Countifs to find more than one criteria based on date.
    By raovv in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-11-2013, 11:03 AM
  6. COUNTIFS to count data in two columns based on other criteria?
    By Si902 in forum Excel General
    Replies: 4
    Last Post: 07-20-2012, 07:51 AM
  7. [SOLVED] Sum based on criteria in rows and columns
    By EstherJ in forum Excel General
    Replies: 1
    Last Post: 11-01-2005, 07:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1