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.

[Trevor Shuttleworth]

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

Regards

Trevor


"pytelium" <[email protected]> wrote in
message news:[email protected]...
>
> 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 |
> +-------------------------------------------------------------------+
>
> --
> pytelium
> ------------------------------------------------------------------------
> pytelium's Profile:
> http://www.excelforum.com/member.php...o&userid=25521
> View this thread: http://www.excelforum.com/showthread...hreadid=571163
>

[pytelium]

Thanks Trevor