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
Bookmarks