I have a series of numers like this in A1-A3:
976543
287530
296743
Now I want to calculate the combined average of the 3th, 4th and 5th digits in those numbers. So in this example that's the average of 654, 753 and 674 (693.6 in this example).
Right now I'm doing this in 2 steps: first =VALUE(MID(A1;3;3)) and dragging the fill handle down, then I'm calculating the average of the combined results.
I wonder if there's one single formula to calculate all of this.
Sorry for what is probably a dumb and obvious question
976543
287530
296743
Now I want to calculate the combined average of the 3th, 4th and 5th digits in those numbers. So in this example that's the average of 654, 753 and 674 (693.6 in this example).
Right now I'm doing this in 2 steps: first =VALUE(MID(A1;3;3)) and dragging the fill handle down, then I'm calculating the average of the combined results.
I wonder if there's one single formula to calculate all of this.
Sorry for what is probably a dumb and obvious question