Count Items Based on Another Column
Grren is New & Red is old products i want to get count of new products, for my reference i removed No for old one formula to get count of only no available products is MB=COUNTIFS(B:B,"*"&C2&"*",A:A,"<>") A B C D No AFO Column1 Column2 1 MB MB 4 2 DT DT 2 3 GPU GPU 3 4 INT+GPU 10 5 AMD+MB 6 Int+MB 7 NVI+GPU 8 DT MB DT MB GPU 9 PCO MB +Lexa (HG) RV DT UMA RV DT+NAVI14 Ref: https://contexturesblog.com/archives/2015/10/15/count-items-based-on-another-column/