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

## Bookmarks