nburaq
Board Regular
- Joined
- Apr 2, 2021
- Messages
- 222
- Office Version
- 365
- 2019
- Platform
- Windows
Hi,
I try to use countifs formula with & for the "Goods" table shown below but it does not work any idea why? Thanks for your help and comments!
=COUNTIFS(Goods[Item]&Goods[Color ];[@Item]&[@[Color ]])
PS: I could use =COUNTIFS( Goods[Item];[@[Item];Goods[Color];[@[Color]) but I think there must be a way with "&"
I try to use countifs formula with & for the "Goods" table shown below but it does not work any idea why? Thanks for your help and comments!
Item | Color | Count |
Desk | Black | |
Desk | Grey | |
Desk | Grey | |
Table | White | |
Table | Black | |
Table | White |
=COUNTIFS(Goods[Item]&Goods[Color ];[@Item]&[@[Color ]])
PS: I could use =COUNTIFS( Goods[Item];[@[Item];Goods[Color];[@[Color]) but I think there must be a way with "&"
Last edited: