Hello I am new to the forum and need help with a problem please. I have a formula that is working but I would like to add more criteria to it:

working now:
=COUNTIFS('Job Entry Form'!A:A,"chegan",'Job Entry Form'!L:L,"Yes")

need to add:
=SUMPRODUCT((B6>=4)*(B6<=7))

Many thanks in advance,
David