Version: 220.127.116.11 (x64) / LibreOffice Community
Build ID: 49f2b1bff42cfccbd8f788c8dc32c1c309559be0
CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: Skia/Raster;
Locale: en-US (en_US); UI: en-US
I have several tables/datasets within a Calc spreadsheet that uses two
Name Box names:
which seem to be working properly.
I am having difficulties and fatigue issues attempting to replace, for
=SUMPRODUCT(RNG_YTD2022>180,RNG_YTD2022<189) , located within a column/cell
=SUMPRODUCT(Career_RNG>180,Career_RNG<189) , located within the same
(BTW: The numeric values 180 and 189 change from within one row to
another row; I wonder also if I should learn about using the FREQUENCY()
I made an attempt to display formulae within the spreadsheet cells and
make use of Find and Replace, w/o success.
I would greatly appreciate suggestions/hints on achieving the
replacement/exchange of the above formulae.
TNX for reading this.
To unsubscribe e-mail to: email@example.com
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
- [libreoffice-users] Editing/Replacement of existing formulae · Vince@Verizon
Impressum (Legal Info)
: 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