ExcelBanter - Averaging Ads in a spreadsheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Averaging Ads in a spreadsheet (https://www.excelbanter.com/excel-worksheet-functions/154336-averaging-ads-spreadsheet.html)

Tanya T.

Averaging Ads in a spreadsheet

One of the workers here has a spreasheet containing 40 items of different
newspaper ad sizes:

2x4
1x10
6x19.9
2x4
5x13
5x13
4x10.5

Is there a way for excel to determine the average size of ads from the list
above? I tried the Average function =Average(range). Didn't work. I got a
DIV/0 error message. Any help would be appreciated. Thanks

Toppers

Averaging Ads in a spreadsheet

=AVERAGE(LEFT(rnga,FIND("x",rnga)-1)*(MID(rnga,FIND("x",rnga)+1,255)))

enter with Ctrl+Shift+Enter

rnga is your range

"Tanya T." wrote:

One of the workers here has a spreasheet containing 40 items of different
newspaper ad sizes:

2x4
1x10
6x19.9
2x4
5x13
5x13
4x10.5

Is there a way for excel to determine the average size of ads from the list
above? I tried the Average function =Average(range). Didn't work. I got a
DIV/0 error message. Any help would be appreciated. Thanks

All times are GMT +1. The time now is 05:16 AM.