Need to count in Q2:Q65, R2:R65 and T2:T65 if the name in N2:N65 = "daniel"
Here is the formula I've used trying to test...
=COUNTIFS(Q2:Q65,"<>",R2:R65,"<>",T2:T65,"<>",N2:N65,"daniel")
Based on this data...
1 N Q R S T U V
2 daniel 1.00 1.00 1.00 1.00 1.00
3
4
But the result = 1 and I need it to be 3 since there is text entered in Q2, R2 and T2
Where am I missing it?
Bookmarks