counting letters.

[pytelium]

I have events in column 1,in my sheet there are about 800 events.
In col 2. each contestant has a label,blue(b),green(g) or red(r)
In column 3 I want to print the number of non reds in each event,in my
attached file this is 7,4 and 4 respectively--I need a formula to fill
down column 3 to do this automatically.


+-------------------------------------------------------------------+
|Filename: 3 letters.zip |
|Download: http://www.excelforum.com/attachment.php?postid=5184 |
+-------------------------------------------------------------------+

 

[Trevor Shuttleworth]

=SUMPRODUCT(($A$2:$A$22=$A2)*($B$2:$B$22<>"R"))

Regards

Trevor

 

[pytelium]

Thanks Trevor