SOLVED

Volleyball sets

Copper Contributor

Hello,

This is volleyball statistics. I would like C3 and E3 be counted sets. How can I do this?Screenshot_2.png

4 Replies

@Smuku 

Could you please clarify where is C3, where is E3 and what to count.

I edited the first post

Count sets, for example in first match should be 2:5

best response confirmed by Smuku (Copper Contributor)
Solution

@Smuku 

In C3: =(G3>I3)+(J3>L3)+(M3>O3)+(P3>R3)+(S3>U3)+(V3>X3)+(Y3>AA3)

In E3: =(G3<I3)+(J3<L3)+(M3<O3)+(P3<R3)+(S3<U3)+(V3<X3)+(Y3<AA3)

Fill down.

Thank you so much. It seems easy now :)
1 best response

Accepted Solutions
best response confirmed by Smuku (Copper Contributor)
Solution

@Smuku 

In C3: =(G3>I3)+(J3>L3)+(M3>O3)+(P3>R3)+(S3>U3)+(V3>X3)+(Y3>AA3)

In E3: =(G3<I3)+(J3<L3)+(M3<O3)+(P3<R3)+(S3<U3)+(V3<X3)+(Y3<AA3)

Fill down.

View solution in original post