sorry for being noisy, but i have a problem that gets me crazy.

I have a mysql database registered with base.

I did a table of writer and connected some fields to cells of that table. i can perfectly print all documents.

But now I want to have a cell which must have as a value the sum of 6 cells.

I explain better.

In that table I have 6 cells which take value directly from db( they are integers) and i would like to have 7th cell which must be the sum of previous 6 cells. In sql it would be SELECT SUM(1+2+3+4+5+6) GROUP BY id.

How can I do?

Sorry, but perhaps I don't know something, because formula =sum<B1:B6> gives me an error in inserting formula (also = sum>B1:B6> does the same).

I'm getting crazy

Thanks

Title Edited. A descriptive title for posts helps others who are searching for solutions and increases your chances of a reply. (TheGurkha, Moderator)