perhaps some of the values are text and not values

the first reference in the range looks like a number
rather than a letter and number.

i am assuming you preface the formula with =

the way i do that operation is to click and drag the
handle in the lower right corner of the first cell
containing the formula.



-----Original Message-----
When I use sum(15:q5), and paste it down a column,
several columns won't be
picked up by the excel formula, even though there is
numerically formatted
data within the range.

Any IDeas
.