Hi, I am using calc to do my books, however when i use the sum symbol to add columns it doesn't like it unless ever row as a figure in it. Is there a way that blank columns default to £0?
Title Edited. A descriptive title for posts helps others who are searching for solutions and increases the chances of a reply (Hagar, Moderator).
Sum columns with blank cells
Sum columns with blank cells
Open Office 4.1.2
Windows 7
Windows 7
Re: Help with Calc - newbie
If you have blanks in the column, highlight all of the cells you want to include in the sum and then click the Sum button.
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.