The following formula works fine in POI (using version 3.15): =SUMPRODUCT(X17:X1048576,--(O17:O1048576>=30))
However, reversing the order of the args, it fails with "Invalid arg type for SUMPRODUCT: (org.apache.poi.ss.formula.eval.ErrorEval)": =SUMPRODUCT(--(O17:O1048576>=30),X17:X1048576) I have an interest, but not the coding chops myself, to see this fixed quickly. It seems like it should be easy since it already works for f(x,y) and just needs to work for f(y,x). I may be able to scrounge up some $ for this, if that helps. Any suggestions on how I might prod this to a quick resolution?
