Microsoft Office Assistance: Summing up ways to add and count Excel data

Check this web page for these forumals to do counts and sum. I didn’t know they had SUMX2PY2 kind of thing. Wow! Great!: “Summing up ways to add and count Excel data”

If you want to See

Add the product of corresponding values in multiple arrays SUMPRODUCT

Add the square of each value in a range SUMSQ

Add the sum of the square of corresponding values in two arrays SUMX2PY2

Add the difference of the square of corresponding values in two arrays SUMX2MY2

Add the square of the difference of corresponding values in two arrays SUMXMY2

Related posts:

1. Super-Easy Guide to the Microsoft Office Excel 2003 Object Model
2. Description of the limitations for working with arrays in Excel 2000, Excel 2002, and Excel 2003
3. Count number of asterisk (*)