range

S

SJ

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!
 
D

Dave Peterson

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