+ Reply to Thread
Results 1 to 4 of 4

COUNTIF Help

  1. 11-03-2013, 04:09 AM #1
    1legin
    1legin is offline
    Registered User
    Join Date
    08-28-2013
    Location
    England
    MS-Off Ver
    Excel 2013
    Posts
    10

    COUNTIF Help

    I dont know if this is possible,

    Numbers 1 - 39 in A2:E24
    Number range in F2:F40
    Last draw - last time number came out in range A2:E24
    COUNTIF - range A2:E? - Last part has to point to the cell which has "Last draw" number
    So as count H2 would be something like COUNTIF(A2:E(G2),F2)

    Thanks in advance

    Workbook attached
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 11-03-2013, 04:17 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,512

    Re: COUNTIF Help

    Try this in cell H2 and copy down =COUNTIF(INDIRECT("A2:E"&G2),F2)

    Is that what you mean?
    Reply With QuoteRegister To Reply
  3. 11-03-2013, 04:18 AM #3
    BadlySpelledBuoy
    BadlySpelledBuoy is offline
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,512

    Re: COUNTIF Help

    DELETED : reply posted twice
    Reply With QuoteRegister To Reply
  4. 11-03-2013, 08:33 AM #4
    1legin
    1legin is offline
    Registered User
    Join Date
    08-28-2013
    Location
    England
    MS-Off Ver
    Excel 2013
    Posts
    10

    Re: COUNTIF Help

    Thanks BadlySpelledBuoy

    Works great - well done
    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] =Subtotal(countif,Range); Subtotal and countif in 1 formula [SOLVED]
    By thomas.mapua in forum Excel General
    Replies: 5
    Last Post: 01-06-2012, 11:33 AM
  2. Combining a Date Range COUNTIF and a general COUNTIF
    By jacobtom in forum Excel General
    Replies: 1
    Last Post: 09-15-2011, 05:06 PM
  3. Adding a CountIF to a formula that is already Countif
    By Cmorgan in forum Excel General
    Replies: 4
    Last Post: 06-01-2011, 09:34 AM
  4. [SOLVED] COUNTIF or not to COUNTIF on a range in another sheet
    By Ellie in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-15-2005, 05:06 PM
  5. Countif w/ Multiple Criteria-How do I use countif
    By Patrick_KC in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-09-2005, 05:05 PM

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