COUNTIFS with Concatenate

[nburaq]

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!

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 "&"

 

[Fluff]

You cannot concatenate the ranges in any of the xxxIFS functions as that creates an array & it only works with a range.

 

[nburaq]

You cannot concatenate the ranges in any of the xxxIFS functions as that creates an array & it only works with a range.

Thanks for the information. Otherwise I was going to be busy with it all day long!

 

[Fluff]

You're welcome & thanks for the feedback.