Ask Your Question
0

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: https://pasteboard.co/GQFGEIr.png

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
0

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

pierre-yves samyn gravatar image

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

Hi

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.

Regards

edit flag offensive delete link more

Comments

Thanks. Did not see that!

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

Question Tools

1 follower

Stats

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

Seen: 2,723 times

Last updated: Oct 26 '17