I am having some trouble adding criteria to an array formula that works well on it's own. So, I believe I am looking to nest added criteria but am not sure where it can fit in the current formula.
I don't fully understand the syntax from the formula I grabbed from an example on the internet. It does what I need in cell B3 but I can't figure out how to modify it for B7, B8 and B9.
What I need is a way to count individual items WITH additional criteria from my list. I feel like I am rambling, attached is my mock spreadsheet with data and yellow hightlights where I need the new formulas. Below is the formula I need to add additional criteria to...
{=SUM(IF(FREQUENCY(IF(LEN(A15:A91)>0,MATCH(A15:A91,A15:A91,0),""), IF(LEN(A15:A91)>0,MATCH(A15:A91,A15:A91,0),""))>0,1))}
Thanks!
Diane
Bookmarks