Ron

I created the file on excel 2003 then transfered it to my desktop with excel
2007 because i could not find the a formula to work in 2003. After finding a
formula on 2007 i transfered the file back to my laptop.

I also created a new file today in 2003 to see if I can use one off the
abovementioned suggestions but i still have problems. I either get a wrong
answer or #Value.

Also made sure that all my add on's was activated.

I am starting to think i have a problem with one of my excel setting on the
laptop but as far as i know all appear to be fine
--
Andrew


"Ron Rosenfeld" wrote:

On Fri, 25 Jan 2008 12:44:11 -0500, "T. Valko" wrote:

But this doesn't make sense:

In 2007 COUNTIFS is working perfectly

That assumes that he opened the exact same workbook in 2007 and then in 2003.
If that is the case, then I would agree with you about it not making sense
because the data should be the same.

But he did not indicate that he had done that.
--ron