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

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

On Mon, 28 Jan 2008 08:03:02 -0800, Andrew
wrote:

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

Andrew,

What result is returned using the SUMPRODUCT formula in 2003?
--ron

Ron

It is calculating 7 -- the number of "New Facility" in G
--
Andrew


"Ron Rosenfeld" wrote:

On Mon, 28 Jan 2008 08:03:02 -0800, Andrew
wrote:

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

Andrew,

What result is returned using the SUMPRODUCT formula in 2003?
--ron

On Mon, 28 Jan 2008 08:55:02 -0800, Andrew
wrote:

Ron

It is calculating 7 -- the number of "New Facility" in G
--
Andrew


In your 2003 workbook

Select Tools/Options/Transition/Workbook Options and DEselect Transition
Formula Evaluation. (You should probably also DEselect Transition Formula
Entry if it is selected).
--ron

On Mon, 28 Jan 2008 08:03:02 -0800, Andrew
wrote:

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

Actually, I should have asked about the result of the SUMPRODUCT formula in
both 2007 and 2003.

ie

Results

SUMIFS (2007):

SUMPRODUCT (in the same 2007 workbook as the SUMIFS):

SUMPRODUCT (2003):

When you created the new file in 2003, how did you get the data from 2007 to
2003? Did you copy a sheet, or did you access it via a web interface?
--ron

Ron

Your suggestion in terms of "Transition"appear to be correct!!! I am going
to do a few more tests but on face it appear to calculate the values correct


In 2007 the calculation was correct as 2. The data on the new worksheet
created is a test captured in the first few rows. I did not copy anything


--
Andrew


"Ron Rosenfeld" wrote:

On Mon, 28 Jan 2008 08:03:02 -0800, Andrew
wrote:

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

Actually, I should have asked about the result of the SUMPRODUCT formula in
both 2007 and 2003.

ie

Results

SUMIFS (2007):

SUMPRODUCT (in the same 2007 workbook as the SUMIFS):

SUMPRODUCT (2003):

When you created the new file in 2003, how did you get the data from 2007 to
2003? Did you copy a sheet, or did you access it via a web interface?
--ron

Ron

Thank You very much it worked. Calculations are now correct
--
Andrew


"Andrew" wrote:

Ron

Your suggestion in terms of "Transition"appear to be correct!!! I am going
to do a few more tests but on face it appear to calculate the values correct


In 2007 the calculation was correct as 2. The data on the new worksheet
created is a test captured in the first few rows. I did not copy anything


--
Andrew


"Ron Rosenfeld" wrote:

On Mon, 28 Jan 2008 08:03:02 -0800, Andrew
wrote:

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

Actually, I should have asked about the result of the SUMPRODUCT formula in
both 2007 and 2003.

ie

Results

SUMIFS (2007):

SUMPRODUCT (in the same 2007 workbook as the SUMIFS):

SUMPRODUCT (2003):

When you created the new file in 2003, how did you get the data from 2007 to
2003? Did you copy a sheet, or did you access it via a web interface?
--ron

On Mon, 28 Jan 2008 09:50:03 -0800, Andrew
wrote:

Ron

Thank You very much it worked. Calculations are now correct
--
Andrew


You're welcome. Glad to help.
--ron