Hi Is there possibility to use skip blank in an array formula? Thanks in advance Jam
J Jamal Hakem Jan 2, 2014 #1 Hi Is there possibility to use skip blank in an array formula? Thanks in advance Jam
I isabelle Jan 8, 2014 #2 hi Jam, =SUMPRODUCT(--NOT(ISBLANK(A1:A3)),--(B1:B3=1)) isabelle Le 2014-01-02 10:29, Jamal Hakem a écrit :
hi Jam, =SUMPRODUCT(--NOT(ISBLANK(A1:A3)),--(B1:B3=1)) isabelle Le 2014-01-02 10:29, Jamal Hakem a écrit :
I isabelle Jan 8, 2014 #3 or A B 1 1 1 2 1 1 3 1 =SUMPRODUCT(--(B1:B5<>""),(A1:A5)) isabelle Le 2014-01-08 18:08, isabelle a écrit :
or A B 1 1 1 2 1 1 3 1 =SUMPRODUCT(--(B1:B5<>""),(A1:A5)) isabelle Le 2014-01-08 18:08, isabelle a écrit :
