Bug 40034 - SUMIF does not work with cells from different sheet.
Summary: SUMIF does not work with cells from different sheet.
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 2.5-FINAL
Hardware: Other other
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2006-07-12 23:59 UTC by Iain Brown
Modified: 2008-05-08 23:27 UTC (History)
0 users


Note You need to log in before you can comment on or make changes to this bug.
Description Iain Brown 2006-07-12 23:59:30 UTC
We are using the HSSF Api's from RPGLE on the system i5 (AS400), and the SUMIF
formula does not work when it references cells on another sheet:
We create a sheet "Detail", containing data, and then create a sheet "Summary"
with formulas such as "SUMIF(Detail!$A2:$A6,$A2,Detail!$E2:$E6)". The cell value
is zero when spreadsheet is first openened, and only becomes correctly populated
when F2 is pressed on the cell, and then enter. (F9 has no effect).

Note: The SUMIF function works fine on the "Detail" sheet when refering to a
range of cells on the same sheet, so it must be the combination of the SUMIF
function, and the sheet reference
Comment 1 Josh Micich 2008-05-08 23:27:06 UTC
Probably due to a bug with token operand classes fixed in bug 44675.