I have 6 columns that have letters say (W) for win (L) for loss and (D) for
draw
I need to total them individually say to 3 win 2 loss 1 draw = 6 in
Total columns.
So need formula to total each in numeral form but they show as letters.in
columns.

=COUNTIF(A1:F1,"W")
=COUNTIF(A1:F1,"L")
=COUNTIF(A1:F1,"D")
of if A2:C2 contain the letters W L D
=COUNTIF($A$1:$F$1,A1)
=COUNTIF($A$1:$F$1,B1)
=COUNTIF($A$1:$F$1,C1)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"koolone" wrote in message
...
I have 6 columns that have letters say (W) for win (L) for loss and (D)
for
draw
I need to total them individually say to 3 win 2 loss 1 draw = 6 in
Total columns.
So need formula to total each in numeral form but they show as letters.in
columns.