Hello!
I am trying to use the formula below but it is not giving me the correct result
=COUNTIF(Q5:Q44,"L")+COUNTIF(Q5:Q44,"NL")+COUNTIF(A5:A44,"EE")
What I want is to count Q5:Q44 if it says NL and L but only if A5:A44 says EE. the problem is that the result should be 2 but is returning 8
my columns so far look like this:
A
1 EE
2 LL
3 BP
4 504
5 EE
Q
1 L
2 L
3 NL
4 NL
5 NL
THEREFORE IT SHOULD ONLY COUNT THE 1st AND 5th ROW WHICH ARE THE ONLY ONES THAT HAVE BOTH CONDITIONS THE "EE" AND THE "L" AND THE "EE" WITH THE "NL"
Bookmarks