Results 1 to 17 of 17

Count IF (match category)

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-29-2017
    Location
    UK
    MS-Off Ver
    Pro Plus 2016
    Posts
    301

    Count IF (match category)

    Hi guys, probably a very simple for you, challenging here as not able to crack the Match or Index ways yet...

    Its as per image and Excel attached - what do we enter to make numbers count based on category match?

    Basically, a formula should look into Column S, and if it finds a matching category in column B, it should make a count.

    Based on given examples, Personal Hobbies should return 8 (and if formula works then it should count well for rest of categories)

    ALSO - just in case its a complicated formula, can we please include IFERROR, to return 0 if cells are blank? Thanking for all of your help!

    https://www.excelforum.com/attachmen...1&d=1509030318
    Attached Images Attached Images
    Last edited by AliGW; 10-26-2017 at 12:06 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Count category as per highest number count
    By arindamsenaxa in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 01-03-2017, 01:13 AM
  2. [SOLVED] Count of occurrences by category
    By dmullin13 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-24-2015, 01:05 PM
  3. [SOLVED] Count items of only one category
    By nooredein in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 05-06-2014, 04:18 PM
  4. Match two category
    By suhabthan in forum Excel General
    Replies: 11
    Last Post: 05-09-2012, 06:50 PM
  5. Count by Category
    By bronkista in forum Excel General
    Replies: 1
    Last Post: 08-04-2011, 06:29 PM
  6. How to Count for each category
    By afriedman in forum Excel General
    Replies: 10
    Last Post: 06-21-2011, 05:33 PM
  7. Count by Category and insert new row
    By karinos57 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-02-2009, 01:41 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