View Single Post
  #16   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ed Ferrero Ed Ferrero is offline
external usenet poster
 
Posts: 115
Default Conditional Sum Incorrect

Great to know, thanks.

Ed Ferrero

"Roger Govier" <roger@technology4unospamdotcodotuk wrote in message
...
Hi Ed

Whilst I replied to Niek in the mvp group, that I could not re-create the
problem, carrying out a save and re-open as you describe, the formula does
display the incorrect value on recalculating.
This was saving in compatibility mode.
When I save as a .xlsx file, then reopen, it works OK.

--

Regards
Roger Govier