Grab the numbers in a cell to another column then get their average. Substitute, AVG not working
heyjay
✭✭✭✭✭
I need to get the TC values only and then get their average (to be place on sheet summary).
But it appears that when you try to use replace or substitute, it is converting them to text.
Value and INT can be used, but I tried both and its not working for my sample.
...
Tags:
Best Answer
Answers
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives