EXCEL 突破30個參數(shù)的限制

 

Exceeding the 30-argument limit
Excel has a 30-argument limit for statistical functions. It's easy to get around, though, if you group some
of your arguments within parentheses().  
For example,Instead of entering SUM(A1,A2,A3…,A33), you can enter SUM((A1,A2,A3),A4…,A33), and Excel will
accept the grouped arguments as a single argument within the formula.