[libreoffice-users] Editing/Replacement of existing formulae

Version: 7.3.2.2 (x64) / LibreOffice Community
Build ID: 49f2b1bff42cfccbd8f788c8dc32c1c309559be0
CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; 
VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL

____________________________________________________________________

Hi:

I have several tables/datasets within a Calc spreadsheet that uses two 
Name Box names:

1. RNG_YTD2022
2. Career_RNG

which seem to be working properly.

I am having difficulties and fatigue issues attempting to replace, for 
example,
=SUMPRODUCT(RNG_YTD2022>180,RNG_YTD2022<189) , located within a column/cell
with
=SUMPRODUCT(Career_RNG>180,Career_RNG<189) , located within the same 
column/cell.
(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() 
function?? )

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.

VinceB.



--
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