does anyone know how to do submations?
J Jerry W. Lewis Sep 22, 2005 #2 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
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