FORMULAS FOR ADDING LETTERS REPRESENTING NUMBERS

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SumIF or CountIF 4
Running Total 3
Working with sports W-L records without Excel assuming I want dates... 0
Percent Formula's 3
Excel Subtracting multiple columns from another column 3
sumif only seeing one row 3
If Formula? 4
IF formula.. 3

Back
Top