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