Hi,

This is slightly convoluted because I'm trying to explain this whole situation. I have a spreadsheet at work tracking customer service complaints. I track the number of days it takes to close a complaint and from there, I track:

(A) the average time it takes to close a ticket [via a simple =AVERAGE("Sustaining items"!L3:3000) function]

(B) the minimum and maximum days it has taken to close a ticket [ with two equations - =MAX(Sustaining items'!L3:L3000) and for the minimum =SMALL('Sustaining items'!L3:L3000,COUNTIF('Sustaining items'!L3:L3000,0)+1) ]

(C) the # of complaints per month [simple =COUNTIF('Sustaining items'!$H$3:$H$3000,">="&Metrics!$B11) ]

(D) monthly items including the number of days to close a ticket per month [=SUMIF('Sustaining items'!$H$3:$H$3000,">="&Metrics!$B11, 'Sustaining items'!$L$3:$L$3000)-SUMIF('Sustaining items'!$H$3:$H$3000,">="&Metrics!$B12, 'Sustaining items'!$L$3:$L$3000) where B11 and B12 are months],

(E) the number of tickets closed per month [=SUMIF('Sustaining items'!$H$3:$H$3000,">="&Metrics!$B17, 'Sustaining items'!$N$3:$N$3000)-SUMIF('Sustaining items'!$H$3:$H$3000,">="&Metrics!$B18, 'Sustaining items'!$N$3:$N$3000) ],

(F) and from the previous two, the average days to close tickets/month [which is the days to close a ticket per month cell divided by the number of tickets closed per month cell].

Somehow, when my coworker was updating our spreadsheet, the macros got messed up. Because the complaint list goes up each day, I have my macros set to count up to the 3,000th column and for months this has worked. However, as of yesterday (according to the coworker), I'm getting mostly #VALUE! returned. This is happening for all of the bullet points listed above EXCEPT the # of complaints per month, so A, B, D, E, and F are broken.

The macros count all the way back to January 2011, and for some reason, D, E, and F are NOT broken past October 2012; however, they use the same equations.

Just in playing around with it, I've noticed that when I only count to column 156, I get real values returned instead of the error. Past 156 it's all #VALUE! .

Does anyone have any idea what's going on?! I'm totally stumped and need to fix this ASAP!! I would appreciate any insight available

Note: I tried to attach screenshots of my workbook. Columns A, B, C, D, E, and F that I listed above are labeled with the corresponding alphabetic letter in green - it does not refer to the actual Excel column. I also have a snapshot of the referred to 'Sustaining items' tab that my macros pull info from. The attaching process isn't working for me, so if you would like to see those please let me know and I can email them.