sumif questions
Adding an example...
Column H Column J Column K
Category Wins/Losses Category S
S W Wins 3
S W Losses 3
S L Percentage 0.500
S W
S L
S L Category O
O W Wins 3
O W Losses 0
O W Percentage 1.000
U L
U L
U W
D L
D W
D L
D W
D W
P L
P W
P W
P W
"BAS" wrote:
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?
|