count ifs with partial match

**Glüscht** · 05-26-2016, 07:45 AM

Ok, I'll try it again. editing does delete also your original post

Once again:

I would like to count cells with two different criteria:

1. If you find the letter from row (a, c, e, a, e) in the column (a, b, c, ab, ca)
2. and values (random) are above the threshold (2), then count

It works fine within the first 3 rows (2 times an a with value above 2, no b above 2 etc.), but as soon as I wanna search partial in cell (a b) it does not count anymore.

What I got so far:

Please Login or Register  to view this content.

I hope the attachment helps for understanding, wasn't sure, how to copy paste.

Thanks for your help!

Glüscht

Screen Shot 2016-05-26 at 13.37.32.png

**Sc0tt1e** · 05-26-2016, 10:18 AM

Is this a countifs?

Please Login or Register  to view this content.

**Glüscht** · 05-27-2016, 04:19 AM

Jep, its countifs in german, once installed Excel in german, hard to change it afterwards....

In the meanwhile, I realised my mistake in the formula. The criteria range consist of "single" entries (a etc), whereas the criteria (C13) contains "multiple" entries (a b). So it make sense, that Excel does not find the multi entries within the single entries of the criteria range.

So the question would be, if its possible the "split up" the "multi" criteria (a b) into a "single" query? Meaning that Excel searches also for parts of the multiple criteria (also for a, instead of a b, within the a b cell) within the criteria range?

Hope to have expressed myself clear enough for understanding.

Thanks for the reply!

count ifs with partial match

LinkBack

Thread Tools

Rate This Thread

Display

count ifs with partial match

Re: count ifs with partial match

Re: count ifs with partial match

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Find partial match between two columns and highlight cells that match

[SOLVED] INDEX MATCH Multiple Output with Partial Match

Formula needed for partial string match as part of index match with multiple criteria

Macro| Search 4 partial match then apply IF statement based on blank cell next to match ?

Partial match using LEFT() in combination with MATCH

Match formula Full match vs. Partial

Trying to match up 2 columns of data on a partial match

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions