Write a function in cell D23 to return the number of employees with greater than 5 and less than or equal 10 years of experience Use structured references to refer to columns in the table. Just really stuck on this problem and could use some assistance

 

Transcribed Image Text:

A Employee Title VP Associate Analyst Analyst Analyst Analyst Analyst Associate Associate Associate Associate VP VP VP VP Analyst VP Associate Associate VP 4 B Sales $ $ 459,460 $ $ 146,775 $ $ 325,137 $ $ 290,638 $ $ 147,404 $ $ 313,022 $ $ 212,137 $ $ 313,035 $ 305,374 $ 347,330 $ 189,182 $ $ $ 394,286 $ 76,949 $ 237,158 $ 160,296 $ 290,063 $ 63,300 $ 385,603 $ 56,642 243,180 $ 152,099 $ 213,710 $ 150,401 $ 432,461 $ 81,417 $ 282,612 $ 161,007 $ 248,448 153034 Salary 281,505 $ 150,205 140,816 189,861 199,746 53,299 102,315 91,258 79,744 74,266 70,832 $115,832 11.72727273 D Years of Experience E US State 8 Oklahoma 14 Texas. 7 Colorado 17 Oklahoma 14 Texas 6 Colorado 12 Oklahoma 11 Texas 10 Colorado 5 Oklahoma 9 Texas 20 Colorado 19 Oklahoma 9 Texas 16 Colorado 11 Oklahoma 10 Texas 5 Colorado 11 Oklahoma 17 Texas F Experience Level G H Commission Rate Average Salary Salary Level A Employee Title VP Associate Analyst Analyst Analyst Analyst Analyst Associate Associate Associate Associate VP VP VP VP Analyst VP Associate Associate VP 4 B Sales $ $ 459,460 $ $ 146,775 $ $ 325,137 $ $ 290,638 $ $ 147,404 $ $ 313,022 $ $ 212,137 $ $ 313,035 $ 305,374 $ 347,330 $ 189,182 $ $ $ 394,286 $ 76,949 $ 237,158 $ 160,296 $ 290,063 $ 63,300 $ 385,603 $ 56,642 243,180 $ 152,099 $ 213,710 $ 150,401 $ 432,461 $ 81,417 $ 282,612 $ 161,007 $ 248,448 153034 Salary 281,505 $ 150,205 140,816 189,861 199,746 53,299 102,315 91,258 79,744 74,266 70,832 $115,832 11.72727273 D Years of Experience E US State 8 Oklahoma 14 Texas. 7 Colorado 17 Oklahoma 14 Texas 6 Colorado 12 Oklahoma 11 Texas 10 Colorado 5 Oklahoma 9 Texas 20 Colorado 19 Oklahoma 9 Texas 16 Colorado 11 Oklahoma 10 Texas 5 Colorado 11 Oklahoma 17 Texas F Experience Level G H Commission Rate Average Salary Salary Level