Ask Your Question
0

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

edit retag flag offensive close merge delete

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

Question Tools

1 follower

Stats

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

Seen: 728 times

Last updated: Oct 26 '17