ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   DIV error (https://www.excelbanter.com/excel-worksheet-functions/101214-div-error.html)

Mark R.

DIV error
 
I have this formula: =IF(M81,"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

DIV error
 
What is the purpose of COUNTIF(July!K3:K20,"=")? Surely it will always give
0.


All times are GMT +1. The time now is 12:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com