How do i total cells in excel that contain specific text?

[Guest]

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

 

[Guest]

For W or L in Col_A

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

Does that help?

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

XL2002, WinXP-Pro

 

[jamex]

To sum both W and L in ur range

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

THANKS

 

[Gilles Desjardins]

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

=COUNTIF(D17,"W")

Gilles

 

[CLR]

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

Vaya con Dios,
Chuck, CABGx3