| Summary: | undefined: sumif function between sheets | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Rance <robr38> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED NOTABUG | ||
| Severity: | normal | CC: | miguelangelrv |
| Priority: | medium | ||
| Version: | 3.5.4 release | ||
| Hardware: | Other | ||
| OS: | Linux (All) | ||
| Whiteboard: | BSA | ||
| Crash report or crash signature: | Regression By: | ||
Hi Rance, thanks for reporting, please can you attach a file sample. Remember delete any private information (this is a public site). I got it figured out. Being stupid. No bug --- On Tue, 1/22/13, bugzilla-daemon@freedesktop.org <bugzilla-daemon@freedesktop.org> wrote: From: bugzileing sla-daemon@freedesktop.org <bugzilla-daemon@freedesktop.org> Subject: [Bug 59647] undefined: sumif function between sheets To: robr38@sbcglobal.net Date: Tuesday, January 22, 2013, 7:34 PM mariosv changed bug 59647 What Removed Added Status UNCONFIRMED NEEDINFO CC mariosv@miguelangel.mobi Ever confirmed 1 Comment # 1 on bug 59647 from mariosv Hi Rance, thanks for reporting, please can you attach a file sample. Remember delete any private information (this is a public site). You are receiving this mail because: You reported the bug. Hi @Rance, no one is perfect. Changed the status to RESOLVED NOTABUG. |
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