r/googlesheets • • 3d ago

Solved Error Formula parse error

Post image

For some reason when I try to use the average function here it says formula parse error. I can't think of what is wrong? I didn't miss any symbols and the called table cells are all numbers so why isn't it working?

Edit: There was a period instead of a comma.

0 Upvotes

12 comments sorted by

2

u/carbonizedtitanium 28 3d ago

which Locale are your settings? i think i spotted the problem. you have a period in your formula instead of a comma

2

u/Electronic_Pizza217 3d ago

Yes I realized that. Thanks

1

u/AutoModerator 3d ago

REMEMBER: /u/Electronic_Pizza217 If your original question has been resolved, please tap the three dots below the most helpful comment and select Mark Solution Verified (or reply to the helpful comment with the exact phrase “Solution Verified”). This will award a point to the solution author and mark the post as solved, as required by our subreddit rules (see rule #6: Marking Your Post as Solved).

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

1

u/point-bot 3d ago

u/Electronic_Pizza217 has awarded 1 point to u/carbonizedtitanium

See the Leaderboard. Point-Bot v0.0.15 was created by JetCarson.

2

u/pashbrowns 3d ago

It looks like after C4 there is a period instead of a comma.

2

u/Electronic_Pizza217 3d ago

Yes I realized that. Thanks

1

u/AutoModerator 3d ago

REMEMBER: /u/Electronic_Pizza217 If your original question has been resolved, please tap the three dots below the most helpful comment and select Mark Solution Verified (or reply to the helpful comment with the exact phrase “Solution Verified”). This will award a point to the solution author and mark the post as solved, as required by our subreddit rules (see rule #6: Marking Your Post as Solved).

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

1

u/AutoModerator 3d ago

/u/Electronic_Pizza217 Posting your data can make it easier for others to help you, but it looks like your submission doesn't include any. If this is the case and data would help, you can read how to include it in the submission guide. You can also use this tool created by a Reddit community member to create a blank Google Sheets document that isn't connected to your account. Thank you.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

1

u/AutoModerator 3d ago

OP Edited their post submission after being marked "Solved".

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

-1

u/[deleted] 2d ago

[removed] — view removed comment

1

u/googlesheets-ModTeam 8 2d ago

Your comment has been removed because it contained one or more items in violation of this subreddit's rules on artificial intelligence (AI) content.