DIV error

[Guest]

I have this formula: =IF(M8>1,"Budget
Made",ABS(M8/(COUNTIF(July!K3:K20,"=")))), which seems to work if July!K3:K20
were numbers I manually typed in but the truth is K3 contains the formula:
=IF(J3<1," ",(SUM(I3:J3))) all the way to K20 - and I get the #DIV/0 error.
Is it because I have a formula referencing cells that contain formulas and
Excel 2000 doesn't like that?

Note: I3:J3 are manually typed sales amount I enter each day. I use the IF
function to make the spreadsheet look nicer (a blank instead of zeros).

 

[Bernard Liengme]

What is the purpose of COUNTIF(July!K3:K20,"=")? Surely it will always give
0.
The M8/0 gives DIV/0!
But something like =IF(M8>1,"Budget Made",ABS(M8/(COUNTIF(July!K3:K20,10))))
will work if these are values of 10 in the range K3:K20
BTW you have extra () in =IF(J3<1," ",(SUM(I3:J3))); just use =IF(J3<1,"
",SUM(I3:J3))
best wishes