Support Board
Date/Time: Wed, 27 Nov 2024 17:35:18 +0000
Post From: Spreadsheet Formulas Disappearing
| [2014-09-05 09:39:57] |
| User16114 - Posts: 153 |
|
The Formula Source Sheet is #1 (from D1 on Sheet20) for a Spreadsheet Study opened on Chart 20, so the chart data appears on Sheet20. When I input the formula below to cell K3 on Sheet1 I get the #NAME? spreadsheet error. When I input the formula below to cell K3 on Sheet20 I do not get the #NAME? error but the formula disappears when the spreadsheet updates. =SUM(ID2.SG1@3+ID2.SG1@17+ID2.SG1@31+ID2.SG1@45+ID2.SG1@59+ID2.SG1@73+ID2.SG1@87+ID2.SG1@101+ID2.SG1@115+ID2.SG1@129+ID2.SG1@143+ID2.SG1@157+ID2.SG1@171+ID2.SG1@185+ID2.SG1@199+ID2.SG1@213+ID2.SG1@227+ID2.SG1@241+ID2.SG1@255+ID2.SG1@269+ID2.SG1@283+ID2.SG1@297+ID2.SG1@311+ID2.SG1@325+ID2.SG1@339+ID2.SG1@353+ID2.SG1@367+ID2.SG1@381+ID2.SG1@395+ID2.SG1@409+ID2.SG1@423+ID2.SG1@437+ID2.SG1@451+ID2.SG1@465+ID2.SG1@479+ID2.SG1@493+ID2.SG1@507+ID2.SG1@521+ID2.SG1@535+ID2.SG1@549+ID2.SG1@563+ID2.SG1@577+ID2.SG1@591+ID2.SG1@605+ID2.SG1@619+ID2.SG1@633+ID2.SG1@647+ID2.SG1@661+ID2.SG1@675+ID2.SG1@689)/50 |