Home |
Search |
Today's Posts |
#1
|
|||
|
|||
sumif formula returns incorrect value
I am using Excel 2000 and have a problem with a sumif formula returning an
invalid solution. A1:Z9 = range G1 through G9 =0 A10 = text B10 = text C10 = null d10 = null e10 = number f10 = text g10 = SUMIF(range,"text",G1:G9) The result of formula in g10 0 If I delete column F then the formula result becomes 0 and is valid. If I delete row 3, the formula result becoems 0 and is valid. Anybody out there seen something like this before? Any solution? Thanks Brian |
#2
|
|||
|
|||
I suspect you have formulas in G1:G9 that are dependent on values in
column F and row 3. Functions operate on stored values, not displayed values (unless you have Tools/Options/Calculation/Precision as displayed selected), so if your formula returns 0.4, but you have the display set for zero places to the right of the decimal point, the display will be 0, but the SUMIF will be non-zero. In article , "modular_brian" wrote: I am using Excel 2000 and have a problem with a sumif formula returning an invalid solution. A1:Z9 = range G1 through G9 =0 A10 = text B10 = text C10 = null d10 = null e10 = number f10 = text g10 = SUMIF(range,"text",G1:G9) The result of formula in g10 0 If I delete column F then the formula result becomes 0 and is valid. If I delete row 3, the formula result becoems 0 and is valid. Anybody out there seen something like this before? Any solution? Thanks Brian |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Standard sumif formula not recognised | Excel Worksheet Functions | |||
IF & VLOOKUP FORMULA | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
How can improve this formula? | Excel Worksheet Functions | |||
How do I prevent incorrect formula results appearing in cell? | Excel Worksheet Functions |