Forum Discussion
Solved
Volleyball sets
Hello,
This is volleyball statistics. I would like C3 and E3 be counted sets. How can I do this?
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.
4 Replies
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 🙂
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
