Forum Discussion
COUNTIFS function
When trying to count the number of cells containing one and the second value, the function returns 0 a a a b b c c c =COUNTIFS(A1:A8;"a";A1:A8;"b")
SergeiBaklan Thanks for the answer! It is very strange that this function does not work for such obvious conditions. Although it works when the condition AND is specified but with the condition NOT EQUAL🤔
For example:
| a |
| a |
| a |
| b |
| b |
| c |
| c |
| c |
| d |
| d |
| d |
| e |
| e |
| e |
5
=COUNTIFS(A1:A14;"<>c";A1:A14;"<>d";A1:A14;"<>e")
These are bit different things. COUNTIFS works with AND on conditions, i.e. counts values for which condition1=TRUE AND condition2=TRUE, etc
Condition itself could be any one - equal, not equal, equal or greater than, etc.
To apply OR on conditions we have to sum results for each of them.
- Thank you!
drubetskiyae , you are welcome
