Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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). |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DIV error
What is the purpose of COUNTIF(July!K3:K20,"=")? Surely it will always give
0. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom error bars not working | Charts and Charting in Excel | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Problem Opening an Excel File MSO9.DLL Error | Links and Linking in Excel | |||
error "module not found" | Excel Discussion (Misc queries) | |||
#REF error | Excel Worksheet Functions |