Ask Your Question

Sum time gives error Err:522

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

solo 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 close merge delete

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
Login/Signup to Answer

Question Tools

1 follower


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

Seen: 728 times

Last updated: Oct 26 '17