by John MacDougall | Aug 31, 2017 | Formulas
Example {=SUM(1*(MOD(B3:B10,2)=1))} Download Example File Generic Formula {=SUM(1*(MOD(Range,2)=1))} Note: This is an array formula. Do not type out the {} brackets. Hold Ctrl + Shift then press Enter while in Edit Mode to create an array formula. Range – This...
by John MacDougall | Aug 30, 2017 | Formulas
Example {=SUM(1*(MOD(B3:B10,2)=0))} Download Example File Generic Formula {=SUM(1*(MOD(Range,2)=0))} Note: This is an array formula. Do not type out the {} brackets. Hold Ctrl + Shift then press Enter while in Edit Mode to create an array formula. Range – This...
by John MacDougall | Aug 30, 2017 | Formulas
Example {=MATCH(FALSE,ISBLANK(B3:B9),0)} Download Example File Generic Formula {=MATCH(FALSE,ISBLANK(Range),0)} Note: This is an array formula. Do not type out the {} brackets. Hold Ctrl + Shift then press Enter while in Edit Mode to create an array formula. Range...
by John MacDougall | Aug 29, 2017 | Formulas
Example {=SUM(1*ISTEXT(FORMULATEXT(C3:C7)))} Download Example File Generic Formula {=SUM(1*ISTEXT(FORMULATEXT(Range)))} Note: This is an array formula. Do not type out the {} brackets. Hold Ctrl + Shift then press Enter while in Edit Mode to create an array formula....
by John MacDougall | Aug 29, 2017 | Formulas
Example {=MATCH(TRUE,ISBLANK(B3:B9),0)} Download Example File Generic Formula {=MATCH(TRUE,ISBLANK(Range),0)} Note: This is an array formula. Do not type out the {} brackets. Hold Ctrl + Shift then press Enter while in Edit Mode to create an array formula. Range...