Forum Discussion
bangerz253
Jul 17, 2019Copper Contributor
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...
Twifoo
Jul 17, 2019Silver Contributor
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”}))
bangerz253
Jul 17, 2019Copper Contributor
- SergeiBaklanJul 17, 2019Diamond Contributor
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.
- TwifooJul 17, 2019Silver ContributorPlease attach your sample file so I could test the formula therein.