Ask Your Question

Sum time gives error Err:522 [closed]

asked 2017-10-26 07:37:41 +0100

solo gravatar image

updated 2020-10-19 00:33:22 +0100

Alex Kemp gravatar image

I have columns formatted as Category: Time, Format: 13:37.

I want to use the formula Sum() to summarize the amount of time used in the columns.

My formula: =SUM(G8:G39)

I get the error: Err:522

This is how my Spreadsheet looks like:

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-10-19 00:33:36.878243

1 Answer

Sort by » oldest newest most voted

answered 2017-10-26 07:47:28 +0100

pierre-yves samyn gravatar image

updated 2017-10-26 07:47:56 +0100


Your formula refers directly to itself: it is entered in cell G39 and the calculated range contains this cell.

FYI you can find all the error codes with their explanation in this help page.


edit flag offensive delete link more


Thanks. Did not see that!

solo gravatar imagesolo ( 2017-10-26 10:41:05 +0100 )edit

Question Tools

1 follower


Asked: 2017-10-26 07:37:41 +0100

Seen: 2,723 times

Last updated: Oct 26 '17