# How to sum a value range with more than one criteria

I have a matrix with a column \”montant\” and two columns \”TypeP\” and \”P\” that I use as criteria.

I want to sum \”Montant\” for only one combinaison of the two criteria.

Thanks for your help.

vb67 Answered question

Hi vb67!

1. Let there are three matrices:

**SD**{*C*:Fields[I:Value, TypeP, P], *C*:Recs[I:Rc1..Rc10]} is some Source Data,

**SmlCrt**{*C*:Criterium[I:TypeP, P]} is Sampling Criteria,

**Report**{*C*:CalcVar[I:Calc1..Calc3]} are Results of three formulas;

and

2. Let the **TypeP** criterion takes values from the range [C1,C2,C3]; the criterion **P** takes values from the range [E1,E2,E3].

Then the sum of the values chosen by the two criteria (**TypeP** & **P**) can be obtained by one of the three formulas (see below).

*

*

Logic:

*

*

Good luck

S A U Answered question