Countif and Sumif functions not working in Excel 2007

[jmroehl]

I have some workbooks that are in Excel 97-2003 (.xls) format. There are
sumif and countif calculations in them, which work fine if I open the
workbooks in Microsoft Excel 2000. However, the calculations are not working
when I open the workbooks in Microsoft Excel 2007. I have tried re-inputting
the formulas, but still get a "zero" result. What's wrong?

 

[Sheeloo]

Can you enter the formulas into a new workbook in Excel 2007 and get the
expected results?

There is no difference between 2003 and 2007 for these two formulas...
Excel 2007 has added COUNTIFS/SUMIFS as new formulas... for multiple
conditions...

Can you paste an example of the formula which is not working?

 

[WTFInc]

I have the exact same problem with SUMIF formulas that have been working for
years. I open the spreadsheet with Excel 2003 and they calculate a correct
value. I open the same spreadsheet in Excel 2007 and they calculate to zero.
Here is an example of one of the formulas:

=SUMIF($R$2:$R$561,"837886",$AT$2:$AT$561)

Column R is made of of all text values, most of which "look" like a number.
If the value in the Criteria does not resemble a number (such as "837886A")
or is stored in column R as a number, then it works correctly. However,
because this spreadsheet is imported into a database, the contents of Column
R must remain as Text.

What has changed in Excel 2007 in the way that numbers formatted as text are
stored?

 

[WTFInc]

Appears to be working with SP2

I have the exact same problem with SUMIF formulas that have been working for
years. I open the spreadsheet with Excel 2003 and they calculate a correct
value. I open the same spreadsheet in Excel 2007 and they calculate to zero.
Here is an example of one of the formulas:

=SUMIF($R$2:$R$561,"837886",$AT$2:$AT$561)

Column R is made of of all text values, most of which "look" like a number.
If the value in the Criteria does not resemble a number (such as "837886A")
or is stored in column R as a number, then it works correctly. However,
because this spreadsheet is imported into a database, the contents of Column
R must remain as Text.

What has changed in Excel 2007 in the way that numbers formatted as text are
stored?