+ Reply to Thread
Results 1 to 11 of 11

IF formula for counting

  1. #1
    Registered User
    Join Date
    04-22-2020
    Location
    Amsterdam
    MS-Off Ver
    365
    Posts
    68

    IF formula for counting

    Hi all,

    I am trying to figure out how to use the IF formula for a case. But I think I am using the wrong formula at the moment... Hopefully someone can help. The figure attached shows the issue.

    Thanks in advance!
    Attached Images Attached Images
    Last edited by AliGW; 04-23-2020 at 01:42 AM.

  2. #2
    Forum Expert
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 365
    Posts
    1,301

    Re: IF formula ?

    does this give you want you want?
    Please Login or Register  to view this content.
    If you want something done right... find a forum and ask an online expert.

    Time flies like an arrow. Fruit flies like a banana.

  3. #3
    Registered User
    Join Date
    04-22-2020
    Location
    Amsterdam
    MS-Off Ver
    365
    Posts
    68

    Re: IF formula ?

    Not yet. He is also given the value of three.

    I have attached the excel file. (Forgot it in the first post, sorry).
    Attached Files Attached Files

  4. #4
    Forum Expert
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 365
    Posts
    1,301

    Re: IF formula ?

    my formula gives identical results to your test data in column J when filled down
    can you give me an example that does not work so I can see what I am missing?

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,801

    Re: IF formula ?

    Will this work for you?
    =COUNTIF(B3:G3,"<150")+I3-1
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  6. #6
    Registered User
    Join Date
    04-22-2020
    Location
    Amsterdam
    MS-Off Ver
    365
    Posts
    68

    Re: IF formula ?

    Yes this one is working, I have added the "=" before 150.
    --> =COUNTIF(B3:G3,"<=150")+I3-1
    Otherwise the value in J4 wasn't correct. Thank you FDibbins. I going to search some more information about the COUNTIF function, I am not very familair with it.

  7. #7
    Registered User
    Join Date
    04-22-2020
    Location
    Amsterdam
    MS-Off Ver
    365
    Posts
    68

    Re: IF formula ?

    The example gave the wrong value at colum J.

    I have used the formula what is given below in this thread, but thank you for the help Scottiex

  8. #8
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    59,037

    Re: IF formula for counting

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

    Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

    Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

    (Note: this change is not optional. As you are new, I have done it for you this time.)

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

  9. #9
    Registered User
    Join Date
    04-22-2020
    Location
    Amsterdam
    MS-Off Ver
    365
    Posts
    68

    Re: IF formula for counting

    Hi AliGW,

    Okay I understand, Thank you and I will try to be as specific as possible in future.

  10. #10
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    59,037

    Re: IF formula for counting

    Please mark the thread as solved as requested in post #8.

  11. #11
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,801

    Re: IF formula for counting

    ooops sorry Ali, got too involved with working on the question.

+ 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. Replies: 3
    Last Post: 03-24-2020, 07:27 AM
  2. Replies: 3
    Last Post: 01-10-2019, 09:34 AM
  3. Replies: 5
    Last Post: 02-16-2018, 06:50 AM
  4. Replies: 8
    Last Post: 09-22-2017, 05:41 AM
  5. Excel formula bar to display the result of the formula , not the formula?
    By max_max in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-18-2016, 07:15 PM
  6. Replies: 11
    Last Post: 06-06-2014, 03:34 PM
  7. how to hide formula in formula box, view lookup result in formula box?
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-14-2013, 04: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