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: [email protected]
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
