![]() |
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). |
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