Countif and Sumif functions not working in Excel 2007

J

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?
 
S

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?
 
W

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?
 
W

WTFInc

Appears to be working with SP2

WTFInc said:
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top