2 array countifs

[jimblimm]

is there any way to make this formula work

=COUNTIFS('MAIN DATA'!$BT$20:$BV$4000,A11,'MAIN DATA'!$K$20:$K$4000,"b11"))


i keep getting a value error

if i split the countifs it works.

COUNTIFS('MAIN DATA'!$BT$20:$BV$4000,A11

COUNTIFS(MAIN DATA'!$K$20:$K$4000,"b11"

 

[Domenic]

Or, we can use Biff's original formula...

=LOOKUP(2,1/((K1:K7="s")*(MMULT(--(BT1:BV7=14),{1;1;1})>0)),A1:A7)