https://bugs.freedesktop.org/show_bug.cgi?id=85985
Bug ID: 85985
Summary: SUMIF Function does not evaluate blank cells against
criteria.
Product: LibreOffice
Version: 4.1.3.2 release
Hardware: x86 (IA32)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Spreadsheet
Assignee: [email protected]
Reporter: [email protected]
Problem description: SUMIF does not evaluate blank cells in the criteria range
to either zero or false or "" (blank), so the only way to sum the values in a
range where the corresponding cell in the criteria range is blank is some form
of summing the entire range and subtracting the conditional sum of all the
values in the range where the corresponding cell in the criteria range is not
blank.
Steps to reproduce:
1. Create 3 columns/ranges, "Units","Bought","Sold" (Number, Date, Date), for
example:
Units | Bought | Sold
45 | 02/07/1996 | 12/03/1999
75 | 05/10/2007 |
33 | 12/22/2013 |
2. Total number currently owned units should be the total of Units that have no
date in Sold (108):
=SUMIF(Sold,"",Units) gives zero (if A1 is blank =A1="" returns TRUE )
=SUMIF(Sold,0,Units) gives zero (if A1 is blank =A1=0 returns TRUE )
=SUMIF(Sold,FALSE,Units) gives zero (if A1 is blank =A1=FALSE returns TRUE )
=SUMIF(Sold,,Units) (error expected but none returned)
SUMIF appears not to return a value to compare against criteria if a cell being
checked is blank. (I have not checked, but wouldn't be surprised if there are
other formulas with a similar problem.)
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
