Sum time gives error Err:522

[solo]

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: Pasteboard - Uploaded Image

[PYS]

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

[solo]

Thanks. Did not see that!