+ Reply to Thread
Results 1 to 4 of 4

How To Countif = ABC, Count Cell A1

Hybrid View

  1. 09-25-2021, 06:03 PM #1
    Keybler
    Keybler is offline
    Registered User
    Join Date
    04-24-2017
    Location
    Virginia
    MS-Off Ver
    2013
    Posts
    50

    How To Countif = ABC, Count Cell A1

    Counting Question. I need a better way to manage preorder products. I've been using excel, but as the preorders increase I spend to much time manually counting. And I know the excel wizards have a better way I can adapt into some excel I will create. If there's something already made up, please let me know.

    Basically need a formula along these lines.

    IF B1 = ABC, Count C1.

    Attached is sample excel. A1:B5 is the intended results for A12:C22.

    Using "=COUNTIFS(B:B,"TV")" I can count number of rows containing "TV" but I need to count the cell to right of the descriptor.

    I always appreciate the help!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 09-25-2021, 06:08 PM #2
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    91,067

    Re: How To Countif = ABC, Count Cell A1

    No, you don’t want a count - you want a sum.

    In B2 copied down:

    =SUMIF($B$12:$B$22,A2,$C$12:$C$22)
    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. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    NB:     as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 09-25-2021, 06:13 PM #3
    Keybler
    Keybler is offline
    Registered User
    Join Date
    04-24-2017
    Location
    Virginia
    MS-Off Ver
    2013
    Posts
    50

    Re: How To Countif = ABC, Count Cell A1

    People like you, is why I love this forum! Thank you. I can work with this.
    Reply With QuoteRegister To Reply
  4. 09-25-2021, 06:14 PM #4
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    91,067

    Re: How To Countif = ABC, Count Cell A1

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

    Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
    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] Countif formula to count based on the timeframe indicate on cell
    By michael35 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-08-2019, 10:42 AM
  2. [SOLVED] COUNTIF for cell range that contains specific text then count data from another cell
    By sluke627 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-08-2019, 04:02 PM
  3. [SOLVED] countif but don't count if cell contains keyword
    By glomb175 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-19-2018, 05:54 AM
  4. [SOLVED] Help .... COUNTIF to count the same word in a cell twice?
    By peterh1967a in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-19-2017, 10:31 AM
  5. [SOLVED] Using COUNTIF to count multiple instances of data in a single cell
    By emsterv in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-14-2017, 06:50 PM
  6. Trouble with COUNTIF, to count a cell or not
    By HSCM in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-10-2014, 11:00 AM
  7. Countif that returns a count based on specific words within a cell
    By wetbean in forum Excel General
    Replies: 3
    Last Post: 12-21-2012, 05:33 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1