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 |
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 |