I fixed it by doing the following in the E column:

=IF(D28="",0,D28-C28)

As opposed to:

=if(D28="","",D28-C28)

On Fri, 21 Mar 2008 13:29:11 -0700, Jason wrote:

I don't see a "tools." (Excel 2007)

But I did discover that the formula will work until I get to the empty
row. If I include data up to the first empty row it works fine. If I
try to include data that goes across the empty rows it fails.
Strange, because the exact same formula works on other spreadsheets.


On Fri, 21 Mar 2008 19:13:12 +0000, GoBow777
wrote:


'Jason[_12_ Wrote:
;642351']Can anybody tell me why they think this formula isn't working.
I have
similar formulas in adjacent worksheets that work fine.

=SUMPRODUCT((E25:E5000)*(F25:F5000=9)*(G25:G5000=6 .5))

I get the #VALUE! error.

No idea why you’re getting the VALUE# error.

To see how Excel is interpreting your formula, click Tools/Formula
Auditing/Evaluate Formula.