+ Reply to Thread
Results 1 to 8 of 8

Count If formula help

  1. #1
    Registered User
    Join Date
    07-03-2019
    Location
    England, UK
    MS-Off Ver
    For office 365
    Posts
    6

    Count If formula help

    Hi,

    I am trying to create a a count if with the below criteria:

    1) Customer name (column A) is a duplicate,
    2) The value in column B is greater than 90% of the original entries value in column B,
    3) The value in column B is less than 110% of the original entries value in column B.

    Thanks in advance for any help,

  2. #2
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Count If formula help

    What do you mean by "the original entries value in column B" ?

    Attach a sample workbook.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  3. #3
    Registered User
    Join Date
    07-03-2019
    Location
    England, UK
    MS-Off Ver
    For office 365
    Posts
    6

    Re: Count If formula help

    Hi Olly,

    Thanks for your help, I have attached a simple sample book.
    Attached Files Attached Files

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,420

    Re: Count If formula help

    If I understand correctly then paste the following into cell C3 and copy down to cell C27: =COUNTIFS(A$2:A2,A3,B$2:B2,">="&B3*0.9,B$2:B2,"<="&B3*1.1)
    If that doesn't yield the results you are looking for then it may help if you manually add the results you expect to the spreadsheet, so that someone can make an attempt to replicate those results using formula/code.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  5. #5
    Registered User
    Join Date
    07-03-2019
    Location
    England, UK
    MS-Off Ver
    For office 365
    Posts
    6

    Re: Count If formula help

    Thanks JeteMc, that seems to work very well.

    Appreciate the help!

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,348

    Re: Count If formula help

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

    Administrative Note:

    Next time you post, please use a better thread title.

    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.
    Ali


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

    Forum Rules (updated August 2023): please read them here.

  7. #7
    Registered User
    Join Date
    07-03-2019
    Location
    England, UK
    MS-Off Ver
    For office 365
    Posts
    6

    Re: Count If formula help

    No problem Ali, sorry about that!

  8. #8
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,420

    Re: Count If formula help

    Thank You for the feedback and for marking the thread as ‘Solved’. I hope that you have a blessed day.

+ 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. Count Blank and count based on criteria only Formula Allowed
    By Harmender in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-21-2019, 12:26 PM
  2. Formula Required to Count Rows only if condition is meet or else dont count
    By Shahbazk in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-22-2017, 08:39 AM
  3. (Count Formula) Count if two seperate ranges create unique combination
    By Geekcrux in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-10-2016, 07:00 AM
  4. Formula to count number of visible rows, and formula to count visible blanks
    By radoncadonc in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-28-2015, 04:19 PM
  5. [SOLVED] Count formula not count hidden cells in table
    By tlacloche in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-06-2013, 02:35 PM
  6. [SOLVED] Count and average formula needed to not count text field
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-07-2013, 05:30 PM
  7. Replies: 5
    Last Post: 08-29-2012, 05:25 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1