Hello all...I've been having calculation issues in excel 97. Let me start by letting you know that the "Automatic Calculation" feature is engaged. Here's my problem:
I have a spreadsheet that contains four tables of formulas: 1)Deficiencies by Material Weakness 2)Deficiencies by Business Process 3) Total Deficiencies and 4)Aging of Deficiencies. The problem with this is that the sum of the Def. by MW and Def. by BP do not equal and neither of the totals concur with the Total Deficiencies.
Other issue happening, I've entered a formula to calculate the aging of outstanding items. When I enter the formulas, it calculates and displays the totals as I desire. I save the workbook, go into another workbook and do some work, but when I come back to the first workbook, the calculations are all "0" and aren't calculating.
Please help....this is bugging the crap out of me because I've seen the formulas work.
And using this formula to sum the aging categories:
COUNTIF(X4:X24,"Not Due")
You can just open excel and enter 10 random dates in column A. Enter the first formula I gave you in column B (referencing column A) and the second formula in column C (referencing column B). Once you get those into place, then set the last formula in column D (referencing column C).
Yeah....its the weirdest thing...it seems to calculate just fine when that's the only thing that's in the spreadsheet. I'm not sure if its not working because I have too many other formulas going on or not.
I'm gonna work on creating a dummy spreadsheet that can better illustrate what's happening on this end. Our helpdesk was just as clueless about what's happening with as my manager and myself. Once I get the dummy spreadsheet completed I'll upload it so you can get a better idea of what's going on.
Also...the Helpdesk here seems to think it may be an Excel 97 issue.
It took me a while but here's an example of what I'm working with. If you sum each table separately, they should all equal the same number of deficiencies.
ETAF....thank you very much! Sometimes all it takes is another set of eyes. Thanks again, this resolves my issues for now. Next I'll have to figure out why when I add my macro to generate charts, that my coworkers get a runtime error but it works for perfect for me.
:up:
Would you now mark this thread solved - which you have the power to do from your first post.
goto
Thread tools>
Tick - Mark Solved
Thanks :up:
when you get around to it - start a new question re the macros and graphs
Status
Not open for further replies.
You have insufficient privileges to reply here.
Related Threads
?
?
?
?
?
Tech Support Guy
9.9M posts
859.7K members
Since 1998
A forum community dedicated to tech experts and enthusiasts. Come join the discussion about articles, computer security, Mac, Microsoft, Linux, hardware, networking, gaming, reviews, accessories, and more!