Re: [libreoffice-users] Updating Data in Calc

Hi Hylton:

Thank you, OM, for giving this problem some thought; I do appreciate 
your suggestion/comments.

I understand your approach in your suggested solution; however, it does 
not satisfy my requirements. The numerical data that is entered, or 
calculated in this situation, within the rows of column [$M] must be 
reflected, overtime, only at cell $Y$4.  (I may later need to assign a 
name for cell Y4; something like: /Predicted Remaining Fuel (Gals)/ for 
use in other, future, calculations).

Perhaps I should have written in my OP that "The formula /presently/ in 
$Y$4=$M18-$W$4". I expect that that formula, obviously,must be changed 
to reach a solution to my problem, but "=SUM(M18-$W$4)" does not do it 
for me. Please note that the updated/reflected numerical data must be 
displayed only within cell Y4, and not elsewhere. Sorry for any 
confusion that I may have caused.


I have other Calc spreadsheets that require this same type of numerical 
data updating.  In 2020 Jan/Feb, I received a workable solution to one 
of my (bowling scores) spreadsheets; IIRC, it invoked the =INDEX( ) 
function, i.e., /=INDEX($'2020-21 WINTER SR LEAGUE'.G6:$'2020-21 WINTER 
SR LEAGUE'.G41,COUNTA($'2020-21 WINTER SR LEAGUE'.G6:$'2020-21 WINTER SR 
LEAGUE'.G41),1)/, but that has somehow gotten messed up by me and no 
longer works (another story, which I may soon write about in another 
thread). I mention =INDEX( ) here because I feel that function, which I 
still do not understand, may be needed to solve my Y4 updating problem.


Thanks again, OM. 73 de WA2RSX

VinceB.


On 6/13/2021 9:01 AM, Hylton Conacher (ZR1HPC) wrote:
> 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 appreciate 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