You don't really need vba for this; assuming the column of figuresbelow is in cells E23:E27 then=COUNTIF(E23:E27,"<19600000")in any other cell should work