I am lost, and confused. I have deleted all of the personal and all that is left is what the formula needs.
I have formulas that will count how many times the date is mentioned. Then how many times a 1 (or in one column a 2) is counted. The numbers are errors that employees made. So it takes how many times the date was counted (total records for that day) then how many times errors happened in that day. It takes these two numbers and gets a percentage. I am using IF(ISERROR, as well as COUNTIF and SUMIF. I don't think the problem is with the formulas, but what is happening is that on dates with double digits (12/10/2010 - 12/31/2010) it is bringing in zeros. However, 12/01/2010 - 12/09/2010 is working perfectly.
I have tried reformatting the dates to be numbers and still nothing. Something strange was this happened once, went home for the night, went back to work the next day and was getting ready to fix it when I realized it was already fixed. Then today it isn't working again and apparently it hasn't been working for a week or so. When I opened up the document it had data and percentages being pulled in from 12/01 - 12/16, then after saving the file it appears to have "re-calculated" and the data that was being pulled in for 12/10 - 12/16 vanished (went back to zeros). I believe looking at the spreadsheet it is self explanatory.
As I have mentioned I am not seeing anything wrong with formulas and I have no idea how to fix it. :-\ At work I have excel 2003, on my home computer I have 2007. I had a file that was 10mb and it wouldn't let me upload a zip file so I had to convert it and delete thousands of rows of data. If anyone can help I would GREATLY appreciate it. And please don't recommend I use a pivot table. The actual file is usually 60mb and adding another pivot will make it a lot larger. There was data all the way up to the 24th but in order to be able to upload I had to remove a lot of the data.
Bookmarks