https://bugs.documentfoundation.org/show_bug.cgi?id=173080
--- Comment #6 from Neil Roberts <[email protected]> --- Maybe the problem is that through some strange quirk of exporting/importing the cells with a 1 have been entered as text instead of numbers. They are formatted differently in the screenshot which seems like quite a good indication. If so, maybe you could work around it by changing the formula to this: =countif(D2:D53;"1") If you put the cursor on one of the 1’s, does the formula bar say '1 instead of 1? -- You are receiving this mail because: You are the assignee for the bug.
