help with excel functions

Job ID: 35605155

Budget: $10 – $30 USD

data set of 500 rows and 2 columns.

1- column A the parameter is any number below a fixed determind number.
2- column B the parameter is any number between an upper limit and a lower limit.

I need a function in excel that will count how many of the data set fall within those 2 conditions mentioned above in 1 & 2.
Related categories: Visual Basic Data Processing Data Entry Excel