Hi everyone,
I have a countifs formula that doesnt work...
I have 2 pages, Matrix and LWmix.Please Login or Register to view this content.
Matrix has 2 column, first is a name, second is a result (the formula goes in the results)
LWmix has tons of name in column A, and numbers between 0 to 5 in column be.
So i want each time the search in LWmix encounter the name in Matrix A3, i want it to countif if B contains a 5.
So if the criteria is met 20 times, 20 will be the ending result.
Bookmarks