when I use this formula in excel it allows me to see my register with all checks that have cleared, however in open libre it gives me a 504 error. How do I correct this
=( INDEX( 0,1,1) + $I$3)-SUMPRODUCT(( 0-(D$4:$E88=“x”)),( 0-(E$4:$F88-F$4:$G88)))
What do you expect INDEX( 0,1,1) to mean?
The first position of an INDEX() expression must be an array.
Help concerning error messages will tell you what Error 504 means:
“Function parameter is not valid, for example, text instead of a number, or a domain reference instead of cell reference.”
In this case it’s a number instead of an array (or a range reference returning an array).
… and after reading INDEX function - Office Support I got some doubt, that this use of INDEX() does work in Excel unless Excel allows to name a range 0.
Post a file using this formula in Excel.