Excel formula needed please

[robfosters]

Should be simple enough for some of you experts.

I have a column of win/loss indicated by a W or L in each cell.

Is there a simple formula that I can put in a cell to calculate the win percentage please?

 

[bremen1874]

Not elegant, but it should give you a starting point:-

=(COUNTIF(H4:H15,"W") / ((COUNTIF(H4:H15,"W") + (COUNTIF(H4:H15,"L")))) * 100)

Change the H4:H15 range to suit your spreadsheet.

 

[robfosters]

Not elegant, but it should give you a starting point:-

=(COUNTIF(H4:H15,"W") / ((COUNTIF(H4:H15,"W") + (COUNTIF(H4:H15,"L")))) * 100)

Change the H4:H15 range to suit your spreadsheet.

Thanks that worked.