LinkBack URL
About LinkBacks
I would like to calculate the numbers average from i4:i20, if the number is followed by this text, īPTS` such as 14PTS. Only numbers with īPTS` should be averaged.
I would like to calculate the numbers average from i4:i20, if the number is followed by this text, īPTS` such as 14PTS. Only numbers with īPTS` should be averaged.
I would create another column for this one and use the formula:
Drag all way down to reach I20, then use average on that column
Please Login or Register to view this content.
I created another column, and the formula worked only on two digit numbers, its not working on one digit number, bellow 10. It shows #VALUE!
Try this
Enter array formula in J4
Array formula must be entered with Ctrl+Shift+Enter key combination.
Formula:
Please Login or Register to view this content.
v I J 4 15PTS 19.25 5 4 6 13 7 12PTS 8 9 4 10 11 33PTS 12 47 13 32 14 41 15 16 54 17 54 18 7 19 20 17PTS
Last edited by AlKey; 08-17-2018 at 06:45 PM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks