S SJ Feb 2, 2009 #1 How do I get Excel 2003 to calculate range? To find mode, for example, I just type =MODE(M4:M8). This doesn't work for range. Help!
How do I get Excel 2003 to calculate range? To find mode, for example, I just type =MODE(M4:M8). This doesn't work for range. Help!
G Gary''s Student Feb 2, 2009 #2 http://en.wikipedia.org/wiki/Range_(statistics) =MAX(M4:M8)-MIN(M4:M8)
D Dave Peterson Feb 2, 2009 #3 Make sure that calculation is set to automatic. (Tools|Options|calculation tab) Make sure that the values in M4:M8 are really numbers--not text. For just 5 cells, I'd reformat the cells as Number (or anything but text). Then reenter each value. (If you've retrieved the values from a web page, you may be including those HTML non-breaking spaces. And then the values won't be real numbers.)
Make sure that calculation is set to automatic. (Tools|Options|calculation tab) Make sure that the values in M4:M8 are really numbers--not text. For just 5 cells, I'd reformat the cells as Number (or anything but text). Then reenter each value. (If you've retrieved the values from a web page, you may be including those HTML non-breaking spaces. And then the values won't be real numbers.)
