|
|
|
|
|
|
|
|
| Cumul
en fonction de critères multiples |
|
|
| Date |
Client |
Montant |
|
Client |
Patricia |
|
| 01.06.2001 |
Claude |
504.00 |
|
Date début |
02.06.2001 |
|
| 03.06.2001 |
Patricia |
384.00 |
|
Date fin |
10.07.2001 |
|
| 08.06.2001 |
Alain |
16.00 |
|
1'676.00 |
|
| 15.06.2001 |
Christian |
947.00 |
|
| 16.06.2001 |
Patricia |
526.00 |
|
| 25.07.1900 |
Claude |
777.00 |
|
| 04.07.2001 |
Alain |
71.00 |
|
| 09.07.2001 |
Patricia |
766.00 |
|
| 13.07.2001 |
Claude |
959.00 |
|
| 21.07.2001 |
Patricia |
778.00 |
|
| 29.07.2001 |
Alain |
421.00 |
|
|
|
{=SOMME(C5:C15*(B5:B15=F4)*(A5:A15>=CNUM(F5))*(A5:A15<=CNUM(F6)))} |
| {formule
matricielle} CRTL+MAJ+ENTER |
|
|
|
|
|
|
|
|
|
