If you retype America in A1 (should read K2)....

Dave Peterson wrote:

Are you sure you have the string "America" in any of those cells?

If the data has been refreshed, maybe some extraneous spaces (leading/trailing)
have shown up.

If you retype America in A1 of that sheet, does the formula update?

If no, then make sure you have calculation set to automatic:
tools|options|calculation tab

If yes, then check for those extra characters.

CindyW wrote:

I have Excel 2002 (I know, way out of date, but I have to use what the
company provides) and have suddenly started having problems with a 'countif'
formula.

The workbook in question has worked fine until last week, when all of a
sudden my 'countif' formulas no longer display the result.

Here's one of the formulas: =COUNTIF('Team
Verification'!$K$2:$K$1355,"AMERICA")

The data on the tab 'Team Verification' is in it's proper place (column K).
When I put my cursor on the cell containing the COUNTIF formula and click on
the AUTOSUM function button to bring up the Function Arguments window, it
shows in that window the correct Formula Result, but the result showing in
the cell is '0'.

I have checked the formatting of the cell (I read through most of these
topics!), and have changed it to 'number' or 'general', but neither made a
difference.

I tried using copies of this workbook from a few weeks back that worked fine
then, but the same thing happens when I paste the new data onto the 'Team
Verification' worksheet.

I am really stumped. The COUNTIF function of Excel is one I've used a lot
over the past 10 or 12 years in various versions of Excel. Any help will be
greatly appreciated!!!

--

Dave Peterson

--

Dave Peterson