Mar 16 2019 10:31 AM
My problem: Per the screenshot below, I seem to have an array that I can't locate and don't recall creating. I can't seem to delete and cutting columns or inserting columns doesn't fix. Frustrating. If I "cosmetically" attempt to fix by having K46 =K45 I get a Spill Error in J46. Error only happens when I put the ISTEXT(E46:I46) formula together. How do I resolve? Driving me nuts. Chris Hunter, Farmington, NM
Mar 17 2019 09:13 AM
You appear to have tested the contents of 5 cells so you should expect to get 5 answers, each comprising the message or the sum. This would be true for either a CSE array or a spilt dynamic array.
To get a single result combine the Boolean array using OR
= IF( OR( ISTEXT(array) ), "Error message", SUM(array) )
Mar 18 2019 07:13 AM
@Peter Bartholomew Thank you so much! Couldn't find documentation on this issue anywhere and really appreciate your timely accurate response. Formula works.
Chris Hunter
Farmington, NM