Results 1 to 9 of 9

COUNTIFS between two ranges

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-29-2013
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2010
    Posts
    143

    COUNTIFS between two ranges

    Hello all,

    Ok, I feel like I'm missing something really easy, but I'm trying to count the number of times a particular color was washed after the date it was stained. This is the formula I am using: =COUNTIFS($B$2:$B$5,$B$2:$B$5<$C$2:$C$5,$A$2:$A$5,A2)

    So, basically for those who don't want to open the file, I'm trying to compare two set of ranges on a 1:1 basis.

    Any help would be greatly appreciated. Thank yoU!
    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. [SOLVED] countifs and date ranges
    By esaban in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-28-2014, 06:49 PM
  2. Need to combine several countifs for the same ranges
    By kbb222 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-10-2013, 06:45 AM
  3. [SOLVED] Countifs and Date Ranges
    By MercyMercyMe in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 03-08-2013, 07:16 PM
  4. COUNTIFS with cell ranges
    By 1.zer0 in forum Excel General
    Replies: 8
    Last Post: 10-01-2010, 06:43 AM
  5. Using COUNTIFS with dynamic ranges?
    By Kagemucha in forum Excel General
    Replies: 5
    Last Post: 07-01-2007, 11:25 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