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

A B C D
1 year number
2 2006 3
3 2005 1
4 2005 2
5
6
7 1 2 3
8 2005 ***
9 2006


***=sumproduct((a2:a4=$A$8)*(b2:b4=$B$7))


then copy formula down and across and you will have a real time
calculating table....


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=524753

If that is the way the data looks, also consider using a Pivot Table under
the Data menu.

--
Regards,
Tom Ogilvy


"robert111" wrote:


A B C D
1 year number
2 2006 3
3 2005 1
4 2005 2
5
6
7 1 2 3
8 2005 ***
9 2006


***=sumproduct((a2:a4=$A$8)*(b2:b4=$B$7))


then copy formula down and across and you will have a real time
calculating table....


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=524753