I have a worksheet w/column named "Reject reason" in Column A2:B10.
D & E collumn must be filled automatically when I entered "REJECT REASON" &
"COMP?"(see (2)=).
------------------------------------------------------------------------------------------------
(1)=

A B D
E
"Code #" "Rejects Reasons" "Comp A" "Comp B"
1 Contract
2 Ethnic Channels
3 Install probs
4 NFL
5 No Pitch
6 No Computer
7 Other Programming not avail
8 Owes us money
9 Previous service problems
10 Price too high


-------------------------------------------------------------------------
(2)=

In a cell range H10:I20, I have the Following:These values I have to entered
myself.
H I
"REJECT REASON" "COMP?"
1 A
5 A
10 B
7 A
3 B
5 B
1 A
5 B

-----------------------------------------------------------------------------------------

Ok, The collums D & E must count how many "Reject reasons" for each A 0r B
Comp?...



In this case it should look like this:
A B D
E
"Code #" "Rejects Reasons" "Comp A" "Comp B"
1 Contract 2
2 Ethnic Channels
3 Install probs
1
4 NFL
5 No Pitch 1 2
6 No Computer
7 Other Programming not avail 1
8 Owes us money
9 Previous service problems
10 Price too high
1

----------------------------------------------------------------------------------------------

I looks simple, but I just don't know how to do it.
Pls help me.



Thanks all.