Getting information from 2 difference formatted columns

S

Sandy

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
 
R

robert111

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 tim
calculating table...
 
T

Tom Ogilvy

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