Forum Discussion
Mean, Median and Mode among sheets in the same Spreadsheet
I have applied the formulas of mean, median and mode among different sheets in the same spreadsheet, but the MODE formula is giving me an error. Any help: =+MEDIANA(Analia:Santiago!F6) Result is...
I’m no expert but why wouldn’t it be...
=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.)
=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.
