how come this = 0 and not #REF or something?
=SUM(G8,#REF!) = #REF! as expected
=SUMIF(E7:E12,#REF!,F7:F12) = 0 too.
All in 2007 (and 2010), I don’t have a 2003 to check just now, is it the same? (just the SUMIF obviously, you dinosaurs don’t have the luxury of SUMIFS ;-))
OpenOffice returns the #REF! I would expect.
Would you expect a formula to return an error if one of its required arguments is an error?
In fairness if there are #REF!s in the data it matches them and returns the total, so in a literal sense it ‘works’, but I’m not sure its what I would expect. What about you?