sumif acting strange

[Guest]

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

 

[Guest]

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.

 

[Jerry W. Lewis]

Change the offending formulas from SUM to COUNT, if the result is less
than you expected, then you have some text strings that only look like
numbers.

Formatting changes the appearance, not the value of a cell. In
particular, putting a numeric format on a cell that contains a text
string of digits will not change that text string into a number.

Copy an empty cell and Edit|Paste|Special|Add over the offending ranges,
and Excel will convert the text digits into numbers.

Jerry