Forum Discussion
Mean, Median and Mode among sheets in the same Spreadsheet
Ok. But I find very strange that this family of statistical functions like mean, median, and even standard deviation work fine, and mode not. Why would not the Mode function accept 3D references? I believe this is an error of Excel. Would it be posible that Excel porgramers fix this?
Thank you
=MODE.SNGL(Analia:Santiago!F6)
I thought that was the preferred syntax, but again, I’m no expert. (I just happened to be trying to use the mode function and came across this.)
Ok, that is probably the syntax in English, which tranllated to Spanish is MODA.UNO(Analia:Santiago!F6). I will try to post this in the Spanish forum.
Do you know if the function as you wrote it works?
No, it doesn't work. List of functions which support 3D reference is within this post https://www.ablebits.com/office-addins-blog/2015/12/09/excel-3d-reference-formula/
It's relatively old, but I don't think something changes.
Than you SergeiBaklan
Your post is clear, I will send a post over there and also check if LibreOffice works with the mode function and 3D references.
Regards.
