Hi Guys! I need a little help, if possible, with a Excel formula.
Assuming a column (M7:M200) has this information:
John
Mary
Lisa
Mark
John
Albert
|_Empty _|
|_Empty _|
|_Empty _|
I would get the sum of the cells except "empty", "John" and "Mark".
The result would be: John: 2 | Mark: 1 | Others: 3 (My only interest is the formula to get the result "Others: 3")
I tried with this formula: = COUNTIF (M7:M200, "<> John") but remains exclude "empty" cells and "Mark."
Thank you for your attention. THX!
Bookmarks