Forum Discussion
Mean, Median and Mode among sheets in the same Spreadsheet
I would expect to see a multi-cell reference to values to be averaged?
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.
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.
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
- 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.)
