3 Replies Latest reply on Nov 15, 2011 10:55 AM by philmodjunk

# SumProduct function?

### Title

SumProduct function?

### Post

Is there anything in FM 11 Pro Advanced that emulates Excel's SumProduct function?

Thanks.

Mike

• ###### 1. Re: SumProduct function?

How does SumProduct work in Excel?

• ###### 2. Re: SumProduct function?

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?

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.