Sumproduct

jenicetan228 · Jul 25, 2006

I heard that sumproduct is very useful. Can I know the functions of it.

Thank you

Dave Peterson · Jul 25, 2006

Biff · Jul 25, 2006

Gord Dibben · Jul 25, 2006

Bob Phillips has just about all you'll ever need to know about SUMPRODUCT

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

Gord Dibben MS Excel MVP

SUMPRODUCT formula is summing text and I want it to stop doing that	2	Aug 1, 2013
sumproduct with three criteria	8	Jul 16, 2013
SUMPRODUCT and SUMIFS combined with Sumifbycolor (VBA code)	1	Apr 10, 2014
sumproduct() function resulted in an error #DIV/0	2	Jan 16, 2013
Question: Using "OR" in SUMPRODUCT Doesn't Work	2	Aug 31, 2009
Sumproducting counting blanks	4	Jul 11, 2013
Fix columns for sumproduct	2	Mar 15, 2012
SUMPRODUCT	1	Jun 11, 2011

Ask a Question