Inside Bracket Formula tabulation question

[27Cool44]

Question: What formula equation will work to:a)sum the numbers inside the brackets b) then divide by only the random cells that have a number.


1. 2. Over (217.0) 3. 4. 5. 6. Over (215.5) 7. Under (200.5) 8. 9. Under (207.0) 10. Over (212.5) 11. 12. 13. 14. 15. 16. Under (206.5) 17. Over (220.0) 18. Over (216.0) 19. Over (213.5) 20. Over (211.5) 21. 22. 23. Under(208.5) 24. 25.

[Pecoflyer]

Is this some kind of homework?

[27Cool44]

Originally Posted by Pecoflyer

Is this some kind of homework?

No it’s a sports software program. I’ve attempted different formulas but can’t seem to arrive at the correct one. Basically I have 25 cells in a column of which somewhere blank and others have input like under (216.5). Since each time the numbers could be different and in different cells I need a formula that takes the numbers out of the brackets add them together and divide by the number of inputs not by 25 south. Thanks for your interest in advance