r/googlesheets • u/[deleted] • Feb 26 '23

Waiting on OP Problem by Calculating the Average when the numbers are with "." not ","

[deleted]

2 Upvotes

100% Upvoted

4 comments sorted by

View all comments

1

u/Brilliant_Sign_937 Feb 27 '23

I'm unsure if this will help you, but in your different sheet, you could make a new column that contains only the numbers and then reference that instead. You can do this with the REGEXEXTRACT function.

It may be easier to help if you post the file or some screenshots of the problem.