Aug 17 2019 04:02 AM
Hello,
Earlier: Eg. Sum A1:A10 in cell B10
Now:
typing . as in step 3 above, and the trying to select the range does not work. The formula after hitting enter key shows =SUM(A10.a1) and returns a #FIELD! error.
Please help
Regards,
Siddhartha
Aug 17 2019 04:48 AM
Yes, dot in a range with SUM doesn't work any more. It was discussed some ago here.
Aug 17 2019 04:50 AM
Aug 17 2019 04:51 AM
It was really a nice trick!
We've discussed this issue before in this link.
Bottom line: this feature is broken or overwritten in recent Office 365 updates due to the new Excel data types (Stocks and geography) that came with the new error type #FIELD!
Aug 17 2019 05:11 AM
Aug 17 2019 05:14 AM
We shall be ready to what some undocumented feature will be broken one day. This one is not the only which eventually stops to work.