我正在尝试制作一个公式,如果满足两个条件,那么它应该从数据中给出准确的结果。 它的答案是0 ArrayFormula(SUMPRODUCT(('Stock In by Invoices'!F5:F=E5)*('Stock In by Invoices'!G5:G=F5)*('Stock In by Invoices'!I5:I2001))) 其答案是#N/A =INDEX('Stock In by Invoices'!I5:I,MATCH(1,('Stock In by Invoices'!F5:F=E5)*(&
10-11 11:29:33.181 20989-20989/me.xingcloud.shop.cateringpad.test W/Bundle: Attempt to cast generated internal exception:
java.lang.ClassCastException: java.lang.String cannot be cast to java.lang.Intege
at android.os.BaseBundle.getInt(BaseBundle.java:801)
at android.os.BaseBundl
我有数据集如下所示
patient number drugtype date date - 1 year date + 1 year
11 G5 1/1/15 1/1/14 1/1/16
16 G5 5/4/13 5/4/12 5/4/14
19 R6 2/1/12 2/1/11 2/1/13
11 G5