Adding another criteria. Each win or loss will also be classified as these
designations: S, O, U, D, or P. So I'd like the function to include this
column (H6:H40), which will allow me to calculate wins/losses by category
found in column H.

"BAS" wrote:

I would like to create a function to sum my wins (W) and Losses (L) and
calculate winning percentage. So, if I have a column (J6:J40) that is a mix
of W's and L's.

I would like to sum: wins in cell K6, losses in cell k7, and winning
percentage in cell k8.

Is the sumif even the right function?