+ Reply to Thread
Results 1 to 2 of 2

Count based on result on another cell

  1. #1
    Registered User
    Join Date
    01-25-2012
    Location
    ...
    MS-Off Ver
    Excel 2007
    Posts
    21

    Count based on result on another cell

    Hello,
    I am using countifs based on criteria of range of days but need to count how many times that was generated on every row. Here is an example to explain what I need to generate:

    Data of number of days:
    =====
    0 —- count of 0 days = 3 times
    42 — count of 42 days = 7 times
    30 — count of 30 days = 3 times

    So based on the above data, the initial count using countifs would be
    6-15 days ———> 0 times
    16-45 days ——> 2 times
    But what I need is to sum all the counts for any particular range . So wanted result for 16-45 days should be 7+3 = 10 not 1. Thanks for help

  2. #2
    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,412

    Re: Count based on result on another cell

    There are instructions at the top of the page explaining how to attach your sample workbook.

    Administrative Note:

    Please update your profile with your current version of Excel.

    Although we value your privacy as much you do, it could be important that members have a rough idea of your location as the solutions they offer may be affected by your locale. For instance, you might in the future post questions which are related to your regional settings.

    With this in mind, please update your profile to something more precise (something such as UK, Europe, USA, UAE, etc. will suffice).

    Thank you for helping us to help you.
    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.

+ 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. [SOLVED] Linking 1 tab to another based on a cell result, picks a column based on result formula
    By MattExcelLearner in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-23-2018, 11:08 AM
  2. [SOLVED] Need help with a formula that will give me a count result based on data in other cells
    By kelmaur in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-15-2018, 01:34 PM
  3. Count Specific Cell Value and Display Result
    By markusvirus in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-30-2015, 05:52 PM
  4. [SOLVED] Pivot for Count and count result as percentage of another cell
    By JEA_123 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-22-2015, 07:54 AM
  5. [SOLVED] How to COUNT cell based on either COLOR or correct result?
    By Kagesen in forum Excel General
    Replies: 3
    Last Post: 05-12-2014, 12:40 AM
  6. Count unique values in columns based on 2 criteria (error in one result)
    By t83357 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-17-2013, 03:25 PM
  7. [SOLVED] Count Rows Based On User Input & Trigger Print Of Pages Out Of Count Result
    By wliang in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-09-2012, 02:45 AM

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