nigelremedios
New Member
- Joined
- Feb 10, 2016
- Messages
- 2
Can someone help, I need to know why this formula is not working =COUNTIFS(A:A,"BE",A:A,"NE",A:A,"IE")
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Can someone help, I need to know why this formula is not working =COUNTIFS(A:A,"BE",A:A,"NE",A:A,"IE")
- Thread starter nigelremedios
- Start date
Andrew Poulsom
MrExcel MVP
- Joined
- Jul 21, 2002
- Messages
- 73,092
Welcome to MrExcel.
Your formula doesn't work because each cell in column A can't contain BE and NE and IE. You need Or rather than AND:
=SUM(COUNTIFS(A:A,{"BE","NE","IE"}))
Your formula doesn't work because each cell in column A can't contain BE and NE and IE. You need Or rather than AND:
=SUM(COUNTIFS(A:A,{"BE","NE","IE"}))
Upvote
0
Similar threads
- Solved
- Question
