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.
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 🙂