Hi,
I've currently got;
=COUNTIFS(INDEX('Training Levels'!B5:K32,MATCH(Shifts!A$5,'Training Levels'!A5:A32,0),MATCH(Shifts!A4,'Training Levels'!B4:K4,0)),1,Shifts!B5,"ASH")
But I'm looking to do this for everyone row that meets this criteria between B5:B35. Something I thought but doesn't...