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
Context
Privacy Policy |
Impressum (Legal Info) |
Copyright information: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License.
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (
MPLv2).
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our
trademark policy.