View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steve Steve is offline
external usenet poster
 
Posts: 1,814
Default Countifs in 2003 = _xlfn. ??

I created some countifs in 2007, saved it down to 2003. When opened in 2003,
in front of the countifs is: =_xlfn.COUNTIFS

It showed correctly in 2003, however, when I added another number in the
range that the countifs were counting, an #name? error was produced, and it
couldn't be undone. Is there any way around this ? Though I'm still impressed
that 2003 was able to keep the 2007 results to begin with. What does xlfn
mean ?

Thanks,


Steve