This content has been marked as final.
Show 3 replies

1. Re: SumProduct function?
philmodjunk Nov 15, 2011 10:00 AM (in response to MikeF)How does SumProduct work in Excel?

2. Re: SumProduct function?
MikeF Nov 15, 2011 10:23 AM (in response to MikeF)Sums columns and rows in aggregate.
One way to sum the example below would be by putting c4*d4 in e4, and so on down the rows, then sum(e4:e6) in e7.
Sumproduct accomplishes that in one formula ..
Column C Column D Row 4 85.00 1,000 Row 5 75.00 1,700 Row 6 65.00 500 245,000.00 =SUMPRODUCT(C4:C6,D4:D6) 
3. Re: SumProduct function?
philmodjunk Nov 15, 2011 10:55 AM (in response to MikeF)Hummm, that's sums the products of the values in each row...
Does a "row" of your data represent one Record?
then the equivalent in FileMaker is to likewise do a two step calculation.
Use Sum (or a summary field) to compute the total of a calculation field. The calcultion field would compute the product of the fields of one record.