Playing with Colors

http://www.cpearson.com/excel/colors.aspx

Using SumProduct

Sumproduct is by far one of the most powerful and versatile functions provided by Excel. In its most basic form, SUMPRODUCT multiplies corresponding members in given arrays, and returns the sum of those products. This page discusses the classic use of SUMPRODUCT, how creativity and inbuilt flexibility has enabled it to evolve into a far more useful function, and explains some of the techniques being deployed. Finally, some examples of SUMPRODUCT show its versatility.

The link below shows the use of Sumproduct.


http://www.xldynamic.com/source/xld.SUMPRODUCT.html