Timeline for Average of only the numeric part of cell values when some of the cells contain text and numeric values
Current License: CC BY-SA 4.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 17, 2019 at 8:53 | comment | added | Tedinoz |
You can add an iferror for each cell, but frankly I wouldn't bother. The answer by @marikamitsos is far, far better.
|
|
| Nov 15, 2019 at 16:56 | comment | added | Clayton | Although it is bulky, this works really great for the example I have provided! The one issue that I am realizing is that if any of the cells that are being averaged are empty, this will cause an error in the calculation. Normally, the average function will skip over empty cells, which is what I'd prefer if that's possible. Any ideas? | |
| Nov 15, 2019 at 1:24 | history | edited | Tedinoz | CC BY-SA 4.0 |
deleted 1 character in body
|
| Nov 15, 2019 at 1:19 | history | answered | Tedinoz | CC BY-SA 4.0 |