I want to count the number of times the following conditions are met. I am trying to use the COUNTIFS function but I got stuck when the criteria can be any of 3 options. I don't want to count the pink apples.
Column A="Apple"
AND Column B="red" OR Column B="Yellow" OR column B="Green)
Please see attachment
Thanks
This formula will give you an "OR"
=SUM(COUNTIFS(A1:A16,"apple",B1:B16,{"Red","Yellow","Green"}))
....or for your example this will give the same result
=COUNTIFS(A1:A16,"apple",B1:B16,"<>Pink")
Audere est facere
Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks