Question: I am using a program called FilterPro to design an electronic filter. The filter has some associated data, which you can export to Excel. In FilterPro the data looks like this, where they use a decimal **comma** instead of a decimal **dot**.

[![enter image description here](https://i.stack.imgur.com/SYhbo.png)](https://i.stack.imgur.com/SYhbo.png)

FilterPro has a feature where you can export to Excel. However, when you export to Excel, they fit all the data into one column, where the different parameters are separated by a comma. So the numbers use decimal comma and they are also separated by a comma...

[![enter image description here](https://i.stack.imgur.com/BAMql.png)](https://i.stack.imgur.com/BAMql.png)

I want it such that each parameter (Frequency (Hz), Frequency (rad/sec),...) has their own column of data. However, because the numbers use decimal comma I cannot use Excel's text-to-columns to do this, because the numbers become wrong.

[![enter image description here](https://i.stack.imgur.com/uwYq8.png)](https://i.stack.imgur.com/uwYq8.png)

Answer: 
I decided to try harder to figure it out myself. The following works well:

=IF(COUNT(B$12:B12)>=10,AVERAGE(INDIRECT(ADDRESS(ROW()-9,COLUMN(B12))):B12),(SUM(A3:A$11)+SUM(B$12:B12))/10)

Thanks again.
Start with

```
=(sum(A3:A$11)+sum(B$12:B12))/10

```

Copy down. Screenshot uses `=formulatext(G4)` copied down to show formulas

[![enter image description here](https://i.stack.imgur.com/zDAjc.png)](https://i.stack.imgur.com/zDAjc.png)

**Edit**

If there is only ever one number between columns A and B, then your formula can be a lot simpler. In C12 you can use

```
=Sum(A3:B12)/10

```

Copy down.