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"