B bines53 Active Member Mar 13, 2016 #1 Hello friends, I am looking for a shortcut formula, without helped column C, to achieve a result like cell F2. Without volatile function. Thank you ! David Attachments test.mod.xlsx test.mod.xlsx 9.3 KB · Views: 18 Last edited: Mar 13, 2016
Hello friends, I am looking for a shortcut formula, without helped column C, to achieve a result like cell F2. Without volatile function. Thank you ! David
John Jairo V Well-Known Member Mar 14, 2016 #2 Hi @bines53 Try this (CSE): =SUM(--(MMULT(--(MOD(A2:A26,TRANSPOSE(ROW(1:4000)))=0),ROW(1:4000)^0)=4)) or this (no CSE): =SUMPRODUCT(--(MMULT(--(MOD(A2:A26,COLUMN(A:EWV))=0),ROW(1:4000)^0)=4)) Blessings!
Hi @bines53 Try this (CSE): =SUM(--(MMULT(--(MOD(A2:A26,TRANSPOSE(ROW(1:4000)))=0),ROW(1:4000)^0)=4)) or this (no CSE): =SUMPRODUCT(--(MMULT(--(MOD(A2:A26,COLUMN(A:EWV))=0),ROW(1:4000)^0)=4)) Blessings!
Hui Excel Ninja Staff member Mar 14, 2016 #3 =SUMPRODUCT(--(C2:C26=4)) =SUM(IF(C2:C26=4,1)) Ctrl+Shift+Enter
B bines53 Active Member Mar 14, 2016 #4 Hi @John Jairo V, I said before, and now, you're a genius ! Thank you ! David
