Forum Discussion

Copper Contributor

Jun 20, 2020

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

excel

Formulas and Functions

Pata05

Copper Contributor

Jun 20, 2020

Thank you Peter.

I am not sure I understood your comment. I am using to calculate the mode the same cell range I used for Mean and Median with no porblem and it gives me the correct result, but for some reason when I try to use the Mode formula it does not work and it shows that #¡REF! in the cell.

PeterBartholomew1

Silver Contributor

Jun 20, 2020

Pata05

Sorry, I didn't look carefully enough and thought

Analia:Santiago!F6

was a single cell reference.

It appears that MODE does not accept 3D references. Not all functions do.

Pata05
Copper Contributor
Jun 21, 2020
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
- EG3EG3
  Copper Contributor
  Jun 21, 2020
  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.)
  - Pata05
    Copper Contributor
    Jun 21, 2020
    EG3EG3
    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?