Sumproduct

[Rahul Mishra]

Sir do you have any either link or file for sumproduct formula's

i wanna learn sumproduct formula's

 

[Khalid NGO]

Hi Rahul,

for startup visit this:
http://chandoo.org/wp/2009/11/10/excel-sumproduct-formula/

for advance go through:
http://chandoo.org/wp/tag/sumproduct/

Regards,

 

[Khalid NGO]

One more:
http://www.excelhero.com/blog/2010/01/the-venerable-sumproduct.html

 

[Rahul Mishra]

Sir why use like this -- in sum product formulas

=sumproduct(--()

 

[Khalid NGO]

To convert Boolean values (TRUE/FALSE) into Numeric values (1/0)

Explanation here:
http://www.mcgimpsey.com/excel/formulae/doubleneg.html

 

[Hui]

Being slightly biased I'd recommend you start with:
http://chandoo.org/wp/2011/12/21/formula-forensics-no-007/

and for advanced usage:
http://chandoo.org/wp/2011/05/26/advanced-sumproduct-queries/