CountIf

Try Sumproduct

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

VBA Noob

Yes that worked - I used both the sum array and sum product effectively. Only problem is it doesn't seem to like using the name as the range.

Sumproduct() does not allow full column referencing, i.e. A:A cannot be used, so if your named range is the full column, then it won't work in Sumproduct()... you can redefine your range to a defined range, e.g A1:A1000... (you can't use A1:A65536 either....you can use A2:A65536 or A1:A65535)....