+ Reply to Thread
Results 1 to 3 of 3

Using Count Ifs on Range

  1. 03-14-2016, 10:45 AM #1
    ScabbyDog
    ScabbyDog is offline
    Valued Forum Contributor
    Join Date
    03-03-2009
    Location
    UK
    MS-Off Ver
    MS365 Subscription Excel for Mac
    Posts
    1,017

    Using Count Ifs on Range

    If cell E2 is found in the range ER3:ER5000 then I want to Count all the cells in the range DLx:DPx that are greater than 0, where X is the row where the match is found. Possible?
    Reply With QuoteRegister To Reply
  2. 03-14-2016, 11:00 AM #2
    BadlySpelledBuoy
    BadlySpelledBuoy is offline
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,528

    Re: Using Count Ifs on Range

    Perhaps:

    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    BSB
    Reply With QuoteRegister To Reply
  3. 03-14-2016, 11:13 AM #3
    newdoverman
    newdoverman is offline
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Using Count Ifs on Range

    One possible way
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W
    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] Count items not included in a data validation range sourced from named range
    By L plates in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-10-2015, 01:05 PM
  2. Auto-Fill a data range from a dynamicly growing range with a Count Function...?
    By AustinLe in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 06-24-2014, 09:27 AM
  3. [SOLVED] Count number of occurances below a range, within a range, and below a range
    By maacmaac in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-15-2013, 11:36 PM
  4. [SOLVED] Count in a range, where identical adjacent cells count as one instance.
    By the-algebraist in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-05-2013, 11:18 AM
  5. Count cells from range that differ from another range based on multiple criteria
    By bward2 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-11-2012, 12:40 AM
  6. Range.columns.count property returns wrong count after union operation
    By gopinan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-13-2008, 04:48 AM
  7. How to count dates within a certain range in a column with mutiple date range entries
    By Krisjhn in forum Excel Formulas & Functions
    Replies: 25
    Last Post: 09-07-2005, 12: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