Support Board
Date/Time: Sun, 24 Nov 2024 06:07:45 +0000
Post From: S/Sheet Study - Formula returns #inval! error
| [2013-09-25 01:20:29] |
| Sawtooth - Posts: 4118 |
|
1. The issue with this formula boils down to INDEX(...):INDEX(...). The colon in this context is the syntax error. This is not supported in the new spreadsheets. The other colons in the formula are valid because they are part of cell range references (X3:X1002), but a colon currently has no meaning between two values.
The colon in this context is not a syntax error. It is the range of the COUNTIF function of the formula in post #1.2. Also, the function COUNTIF was never added due to the complexity of supporting criteria text. (Same with AVERAGEIF, MAXIF, MINIF, SUMIF.)
It is not good news that some existing Excel functions will not be available. Very disappointing to hear that. COUNTIF and SUMIF have been around for years. I was actually hoping for additional functions, like MAXIF and especially MINIF. It's not that the same thing can't be accomplished within 60 columns, but that the functions make it easier to get to the desired result.You should be able to accomplish what that formula is doing by breaking the formula down into separate spreadsheet columns using the more basic functions. Now that 60 formula columns are supported with the spreadsheet studies, there should be no problem with this. It also may make it easier to understand the logic. Date Time Of Last Edit: 2013-09-25 01:51:03
|