I have a column in which each cell contains either "W" or "L"
What formula do I use to total cells that contain either of these two
characters?

thanks

jb

For W or L in Col_A

To count W's:
=COUNTIF(A:A,"W")

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Zurbs17" wrote:

I have a column in which each cell contains either "W" or "L"
What formula do I use to total cells that contain either of these two
characters?

thanks

jb

To sum both W and L in ur range

=COUNTIF(RANGE,"L")+COUNTIF(RANGE,"W")

THANKS


--
jamex
------------------------------------------------------------------------
jamex's Profile: http://www.excelforum.com/member.php...o&userid=32243
View this thread: http://www.excelforum.com/showthread...hreadid=521603

Create a formula for each L and W as follows.
There are other ways like Conditional sum wizard, etc.

=COUNTIF(D1:D7,"W")

Gilles


"Zurbs17" wrote in message
...
I have a column in which each cell contains either "W" or "L"
What formula do I use to total cells that contain either of these two
characters?

thanks

jb

=COUNTIF(A:A,"W")+COUNTIF(A:A,"L")

Vaya con Dios,
Chuck, CABGx3


"Zurbs17" wrote in message
...
I have a column in which each cell contains either "W" or "L"
What formula do I use to total cells that contain either of these two
characters?

thanks

jb