I need to count how many cells in column D have a value in them between 7 and
3.
I cant find anything that lets me use between as criteria and Countif only
allows me to have 1 criteria.

Any ideas?