Re: [libreoffice-users] Updating Data in Calc

Hi Vince,

On 2021/06/12 17:20, Vince@Verizon wrote:
> Hello:
>
> Using LO vers 7.1.3.2 (x64) on desktop Windows 10 Home (64-bit).
>
> I would greatly receiving an explanation of a formula or function in 
> Calc that updates the data within cell $Y$4 each time the data in column 
> [M] changes.  The formula in $Y$4 =$M18-$W$4.
>
> [M]                                        [Y]
>
> Row 18 ---------------------->  Row 4
> Row 19 ---------------------->  Row 4
> Row 20 ---------------------->  Row 4
> Row 21 ---------------------->  Row 4
> Row 21 ---------------------->  Row 4

 Where is column W in your layout? The below is done on assumption.

A simple sum will do it i.e.:

In cell Y4 insert everything between the "

"=SUM(M18-$W$4)"

In cell Y5

"=SUM(M19-$W$4)"

In theory you could just drag the formula from cell Y4 down to the 
bottom and then just change those M reference cell numbers.

Remember that putting a $ before either a letter or number reference of 
a cell LOCKS that formula i.e. dragging the formula down a column to 
populate cells below will keep whatever is prefixed with $.

Hope it helps
Hylton

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy