Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sumif acting strange
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
sumif acting strange
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 . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
sumif acting strange
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 JEff wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel acting up | Excel Discussion (Misc queries) | |||
Menu Bar acting strange | Excel Discussion (Misc queries) | |||
SUMIF, wrong result, strange behaviour | Excel Worksheet Functions | |||
Help...my charts are acting up! | Charts and Charting in Excel | |||
Paste is acting up | Excel Worksheet Functions |