software

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: www.excelforum.com/member.php...oamp;userid=31996
View this thread: www.excelforum.com/showthread...hreadid=524753If that is the way the data looks, also consider using a Pivot Table under
the Data menu.

--
Regards,
Tom Ogilvyquot;robert111quot; wrote:

gt;
gt; A B C D
gt; 1 year number
gt; 2 2006 3
gt; 3 2005 1
gt; 4 2005 2
gt; 5
gt; 6
gt; 7 1 2 3
gt; 8 2005 ***
gt; 9 2006
gt;
gt;
gt; ***=sumproduct((a2:a4=$A$8)*(b2:b4=$B$7))
gt;
gt;
gt; then copy formula down and across and you will have a real time
gt; calculating table....
gt;
gt;
gt; --
gt; robert111
gt; ------------------------------------------------------------------------
gt; robert111's Profile: www.excelforum.com/member.php...oamp;userid=31996
gt; View this thread: www.excelforum.com/showthread...hreadid=524753
gt;
gt;