https://bugs.freedesktop.org/show_bug.cgi?id=59647
Priority: medium Bug ID: 59647 Assignee: libreoffice-bugs@lists.freedesktop.org Summary: undefined: sumif function between sheets Severity: normal Classification: Unclassified OS: Linux (All) Reporter: rob...@sbcglobal.net Hardware: Other Whiteboard: BSA Status: UNCONFIRMED Version: 3.5.4 release Component: Spreadsheet Product: LibreOffice Problem description: I have 9 sheets, 8 are renamed. on named sheets sumif(b3:b120,"Pantry",a3:a120) works. On sheet1, sumif(vegs.b3:b120,"Pantry",a3:a120) does not work, I receive 0 result.Is this the wrong way to reference? Steps to reproduce: 1. .... 2. .... 3. ....3:b120 Current behavior: Expected behavior: 120 Operating System: Ubuntu Version: 3.5.4 release -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs