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...
Try this:
=SUMPRODUCT(
(A:A={“Apple”,”Banana”})*
(B:B={“Sold”,”Not Sold”})*
(C:C={“Old”,”New”}))
=SUMPRODUCT(
(A:A={“Apple”,”Banana”})*
(B:B={“Sold”,”Not Sold”})*
(C:C={“Old”,”New”}))
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.
- Please attach your sample file so I could test the formula therein.
