Array Formula problem

  • Thread starter Thread starter MathewS
  • Start date Start date
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)
 
Back
Top