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
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 |
Comments
Post a Comment