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 |
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 |
All times are GMT +1. The time now is 03:09 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com