Summing Data with Data

[howard]

I have data in Col F from row 2 as follows



31 Days
45 Days
65 Days
39 Days Etc


I will like a formula to average these


Your assistance is most appreciated

 

[MARZIOTULLIO]

[TABLE="class: grid"]
<tbody>[TR]
[TD][/TD]
[TD]

F​

[/TD]
[TD]

G​

[/TD]
[/TR]
[TR]
[TD]

1​

[/TD]
[TD][/TD]
[TD]average[/TD]
[/TR]
[TR]
[TD]

2​

[/TD]
[TD]31 Days[/TD]
[TD]

45​

[/TD]
[/TR]
[TR]
[TD]

3​

[/TD]
[TD]45 Days[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

4​

[/TD]
[TD]65 Days[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

5​

[/TD]
[TD]39 Days[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


g2=AVERAGE(SUBSTITUTE(F2:F5,"Days","")+0) control+shift+enter

 

[howard]

Thanks for the help, much appreciated

 

[MARZIOTULLIO]

you are welcome