Ask Your Question

Sum time gives error Err:522

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

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 +0200

pierre-yves samyn gravatar image

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


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 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


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

Seen: 996 times

Last updated: Oct 26 '17