advance countifs

[End3r]

Hello,

i am having trouble getting my formula to work properly.

=COUNTIFS(table_name_first_table[tablerow_name)];"*";table_name_first_table[tablerow_name)];"name";tablename[tableRow_description];"*new*")

So, i want to count how many times name of the person shows up given two criterias. First criteria is "name". Second criteria is that i need the word "new" to appear in row "description". And this works perfectly but i also have another row where i do same counting but for word "old". This description can have, due to history of description both "new" and "old" and i need to count only the first one that appears. So, in table row "new" if you first get to the word "old" then count 0, otherwise 1. If in the row "old" if the first word is "new" then count 0, otherwise count 1.

Thanks for all your help !

E

 

[End3r]

Re: advance countifs with a twist

Oh, sorry...

2. Ok, so, in my database, all IDs starting with number "1*" are "MOB", all IDs starting with number "6*" or "8*" are "FIX". I posted the count above and changed the text color in a quote. So the count would be 2 in Nova FIX box and 2 in Retention FIX.

Thanks for your help !