Countifs Multiple Named Tables

[Kn0wn1]

Hello,

I'm trying to write a countifs referring to named tables as criteria.

Eg: =sumproduct(countifs(table4[field1],namedrange1, table4[field2],namedrange2))

The named tables contain single column lists, that may vary in size. If i run this with only 1 named table, it works fine, however i cannot get both to work. Any suggestions?

Thanks

Edit: also tried ctrl-shift-enter {=sum(countifs(table4[field1],namedrange1, table4[field2],namedrange2))}

[Tony Valko]

The criteria ranges must all be the same size.

[ChemistB]

As Tony said. Here is an example of how it would work. Format is same as yours except I used a single named range