You'll need to look the range down by doing the following

$B$2:$B$10 - otherwise as you copy the formula down your range will move down a row each time too, so you'll end up missing entries

Posted By: CityForLife, Jul 29, 16:44:47