+ Reply to Thread
Results 1 to 4 of 4

countif using a cell as a criteria

  1. #1
    Registered User
    Join Date
    05-28-2006
    Posts
    60

    countif using a cell as a criteria

    so i have this table:
    1
    2
    3
    4
    5
    6

    now I want to do a count if it's higher than 3.5 so i have this: =countif(A1:A6,">3.5") but what if I want to replace that 3.5 with a cell that contains that info? So cell B1 is 3.5 so I want to instead use that # that is in B1 as the criteria. I tried doing:
    =countif(A1:A6,">B1") but it doesn't work. How read a cell as a criteria? Also I wanted to add to that cell too like B1+2 so the total would be 5.5 if B1 is 3.5 in this example. Or adding 2 or more cells as the total like B1+B2

    Thanks for the help.

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: countif using a cell as a criteria

    =countif(a1:a6,">"&$b$1)

  3. #3
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: countif using a cell as a criteria

    Try it like this...

    =COUNTIF(A1:A6,">"&B1)
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  4. #4
    Registered User
    Join Date
    05-28-2006
    Posts
    60

    Re: countif using a cell as a criteria

    nm i got it.. use & and take it out of the ". just found out.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. COUNTIF?? - I want the cell to have the value 2.5 if criteria is met.
    By eekbubble in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-08-2014, 12:20 PM
  2. [SOLVED] COUNTIF and adding a value to a cell on criteria met
    By Macileo in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 10-07-2013, 01:49 PM
  3. [SOLVED] CountIF /w multiple criteria, one of which is the value of a cell
    By bgrigg in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-06-2013, 11:54 AM
  4. [SOLVED] Excel 2007 : COUNTIF another cell meets criteria
    By MuhammadSami in forum Excel General
    Replies: 4
    Last Post: 06-18-2012, 04:17 PM
  5. Countif Where Criteria References Another Cell
    By mwgr5 in forum Excel General
    Replies: 3
    Last Post: 07-09-2008, 04:09 PM
  6. Replies: 2
    Last Post: 06-16-2007, 02:25 PM
  7. [SOLVED] countif using cell references in criteria
    By Hall in forum Excel General
    Replies: 2
    Last Post: 05-17-2005, 01:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1