+ Reply to Thread
Results 1 to 5 of 5

A quick question about COUNTIF

  1. 04-24-2014, 05:34 PM #1
    Ephy
    Ephy is offline
    Registered User
    Join Date
    02-05-2014
    Location
    canada
    MS-Off Ver
    Excel 2007
    Posts
    17

    A quick question about COUNTIF

    Hello,

    I'm happy to find this place. I just have a quick question about using the Countif formula.

    I have a spreadsheet that identifies a location by a specific color and while trying to calculate the number of times the red, yellow, or blue is listed I've been using the Countif.

    The problem I'm facing now is that because the colors are a data validation drop down list, any updates or additions to the spreadsheet does not calculate automatically and I cant understand why.


    This is my formula =Countif(B2:B20, "Red"), then under that I use it again to calculate the blue, =Countif(B2:B20, "Blue") etc

    It adds up how many times the column has the text "red" , "blue" but if I try to insert a row or change the drop down menu to a different color it does not calculate it automatically, unless I go back down to the formula, click it and hit enter.


    Please tell me what I am missing here? It seems like it would be a simple straightforward formula?

    I'm still very much of a beginner excel user, and I'm sorry if this was asked somewhere else.

    Thank you
    Reply With QuoteRegister To Reply
  2. 04-24-2014, 05:39 PM #2
    Richard Buttrey
    Richard Buttrey is offline
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: A quick question about COUNTIF

    Hi, and welcome to the forum.

    Stating the obvious I know, but are you sure Calculation is set to Automatic? The calculation setting is at the Application level not the Workbook level.

    It sometimes happens that if the very first workbook you open in a new Excel Application instance is set to Manual, it means that all subsequent workbooks will also be affected until you reset the Application.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
    Reply With QuoteRegister To Reply
  3. 04-24-2014, 05:41 PM #3
    GC Excel
    GC Excel is offline
    Forum Expert
    Join Date
    08-02-2013
    Location
    Québec
    MS-Off Ver
    Excel 2003, 2007, 2013
    Posts
    1,412

    Re: A quick question about COUNTIF

    Hi and welcome to the forum.
    Is your calculation mode set to automatic or manual ??
    Press F9 to recalculate and check if the result is update.


    [Edit] Oups. Too late.
    GC Excel

    If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.
    Reply With QuoteRegister To Reply
  4. 04-24-2014, 05:45 PM #4
    Ephy
    Ephy is offline
    Registered User
    Join Date
    02-05-2014
    Location
    canada
    MS-Off Ver
    Excel 2007
    Posts
    17

    Re: A quick question about COUNTIF

    OMG! That is totally it! WOW! I feel like such a noob! :D Thank you! <3

    Thank you so much for the quick answer!
    Reply With QuoteRegister To Reply
  5. 04-25-2014, 08:44 AM #5
    arlu1201
    arlu1201 is offline
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: A quick question about COUNTIF

    Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

    In future, to mark your thread as Solved, you can do the following -
    Select Thread Tools-> Mark thread as Solved.

    Incase your issue is not solved, you can undo it as follows -
    Select Thread Tools-> Mark thread as Unsolved.

    Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]
    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] Quick Countif and And function help
    By FootyMan in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-02-2013, 06:05 AM
  2. [SOLVED] Quick question about automatic row deletion (should be very quick and easy!!)
    By poptart141 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 04-09-2013, 12:56 PM
  3. Quick Question QUick Answer
    By ccraig61 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-25-2006, 09:34 PM
  4. Quick little question
    By ben simpson in forum Excel General
    Replies: 3
    Last Post: 04-11-2006, 09:40 AM
  5. Quick question - quick answer about assigning shortcut keys
    By funkymonkUK in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-13-2005, 06:05 AM

Tags for this Thread

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