You can use the SUM or SUMPRODUCT function to build up some fairly
complicated summations as array formulas. Specifics would depend on the
particular (unstated) summation that you want to perform.

Jerry

submations? wrote:

does anyone know how to do submations?