Hello All, I am new to Mac and am having problems with a formula in Excel 2008 for Mac. I originally created the formula in Windows and it worked fine but now when I am editing the document with my Mac the formula causes an error. Purpose of Formula: I am using the COUNTIFS formula to compare and tally date ranges for when certain paperwork was received as opposed to when it should have been received and the totals. I have one column with the "Appointment" which is when we SHOULD have received the ppwk and a column with "Rec'd" which is when we acutally got it. Both of these columns have dates, i.e 1/29/09 and formatted as such. Then I have two seperate columns that I use the COUNTIFS formula in to tally the Appointments and the received. The problem as I see it is that Excel is not letting me dictate the range beyond a certain point. Here is the Appointments formula that I am using... =COUNTIFS($C$2:$C$96,">=1/1/2009",$C$2:$C$96,"<2/1/2009"). If I try to make the range larger so that I don't have to change the formula each time I add more data like $C$2:$C$1000, it returns a #VALUE error and I can't figure out how to fix it. Does anyone have any ideas why it is not letting me use a larger range? As I said before, the formula worked fine on a Windows machine with the larger range. Thanks.