Can anyone help, I am trying to work out a formula that will look at column A
which has a date ie 21/02/2006 (also have various years) and column E which
has a combination of numbers and text like this 1,2 3, 3 Rej, 4, 5, 6, 6
being the largest.

I need to look at col A and give it a year ie 2006 and then look at col E
and count up if it is either a 1, 2 etc.

I have tried using CountIf, but keep failing.

Thanks in advance