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...
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.