M
MathewS
After entering an Array Formula, and pressing
Ctrl+Shift+Enter the formula does NOT become an Array, no
brackets at the ends.
here's my formula...
=SUM((A2:A500=1)*(G2:G500=1)*G2:G500)
Ctrl+Shift+Enter the formula does NOT become an Array, no
brackets at the ends.
here's my formula...
=SUM((A2:A500=1)*(G2:G500=1)*G2:G500)