[Solved] Using formula on entire column

Discuss the spreadsheet application

[Solved] Using formula on entire column

Postby bigdaddyfred » Tue Apr 30, 2019 10:49 pm

I can easily set up a formula for a individual entry on a column, but i need a cumulative one. Right now the only way i see to enter it is to do each entry in the column individually.

Want to add column H<row> to column I <row-1> for new total amount in column I <row>

I know it is there, i just can't find how to set up the columns to do this.

Thanks
Last edited by bigdaddyfred on Tue Apr 30, 2019 11:09 pm, edited 1 time in total.
OpenOffice 4.1.3 on Windows 10
bigdaddyfred
 
Posts: 1
Joined: Tue Apr 30, 2019 10:45 pm

Re: Using formula on entire column

Postby MrProgrammer » Tue Apr 30, 2019 10:53 pm

Hi, and welcome to the forum.

bigdaddyfred wrote:Using formula on entire column
[Tutorial] How do I specify the formula for a column?

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.

[Tutorial] Ten concepts that every Calc user should know
Mr. Programmer
AOO 4.1.7 Build 9800 on MacOS 10.14.6.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
MrProgrammer
Moderator
 
Posts: 3893
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA


Return to Calc

Who is online

Users browsing this forum: MSN [Bot] and 19 guests