Forum Discussion
Using COUNTIFS with Multiple Or and ANDs
Hello, Looking to use Countifs or countif to solve my problem. Ex. I want to count from the columns A contains (Apple, Banana), B contains (Sold, Not Sold), C contains (Old, new). So I want to count...
If use COUNTIFS when
=SUM(COUNTIFS(A:A,{"Apple","Banana"},B:B,{"Sold","Not Sold"},C:C,{"Old","New"}))
but it gives exactly the same result as Twifoo formula.