Does it work if you use the column/range where the VLOOKUP pulls from?
My guess is that you somehow are not using the correct sheet/range or that
the values are not integers but that they have decimals as well
You can also try
=COUNTIF('OPRS Conv Tracker'!Q51:Q200,"*9*")
Shouldn't really matter and this is just to test if you will get anything at
all..
Try this, select part of the range that you know has a 9, copy it to a new
sheet and paste special as values, wide the column if necessary and if you
see things like
9,000000001
then that is the reason, if so you might want to use round in the
vlookup/sum formulas
You can also try it in the new sheet, if you paste then as values into
A1:A100 or something use
=COUNTIF(A1:A100,9)
--
Regards,
Peo Sjoblom