Results 1 to 3 of 3

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

Threaded View

  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
    66

    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
« 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