G
Guest
Been looking through threads but can't match this one!
ColA ColB
400 1.266%
132 17.857%
1,348 3.932%
1,177 3.155%
1,131 2.818%
14,900 0.000%
601 0.661%
3,102 26.975%
33,228 2.751%
1,498 23.297%
How do I calculate the average in ColB if ColA >500 and <1000 (between 500
& 1000)
ColA ColB
400 1.266%
132 17.857%
1,348 3.932%
1,177 3.155%
1,131 2.818%
14,900 0.000%
601 0.661%
3,102 26.975%
33,228 2.751%
1,498 23.297%
How do I calculate the average in ColB if ColA >500 and <1000 (between 500
& 1000)