I'd like to return a sumproduct of a ranged that can be dynamically modified.
I want to get the sum of a area based on the user, date min and date max criteria.
In this example result would be 5 since a sum of H3 to H6 would be made based on the criterias.
See spreadsheet.
How can this be acheived?
I want to get the sum of a area based on the user, date min and date max criteria.
In this example result would be 5 since a sum of H3 to H6 would be made based on the criterias.
See spreadsheet.
How can this be acheived?
| Analyse-rendement-V5-demiheure.xlsx | ||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | |||
| 1 | User1 | User2 | User3 | User4 | User5 | User6 | User7 | User8 | User9 | User10 | ||||||||||
| 2 | Période-Sem | Min. de Date | Max. de Date2 | Name 1 | Name 2 | Name 3 | Name 4 | Name 5 | Name 6 | Name 7 | Name 8 | Name 9 | Name 10 | Total | ||||||
| 3 | P12-S1 | 2024-01-28 | 2024-02-03 | 0 | ||||||||||||||||
| 4 | P12-S2 | 2024-02-04 | 2024-02-10 | 14 | 4 | 1 | 3 | 22 | Dynamic input | |||||||||||
| 5 | P12-S3 | 2024-02-11 | 2024-02-17 | 0 | Date 1 | 2024-01-28 | (min date column B) | |||||||||||||
| 6 | P12-S4 | 2024-02-18 | 2024-02-24 | 1 | 1 | 1 | 3 | Date 2 | 2024-02-24 | (max date column C) | ||||||||||
| 7 | P13-S1 | 2024-02-25 | 2024-03-02 | 3 | 3 | User: | User5 | Line 1 | ||||||||||||
| 8 | P13-S2 | 2024-03-03 | 2024-03-09 | 1 | 4 | |||||||||||||||
| 9 | P13-S3 | 2024-03-10 | 2024-03-16 | 4 | 4 | |||||||||||||||
| 10 | P13-S4 | 2024-03-17 | 2024-03-23 | 1 | ||||||||||||||||
Stats Erreurs | ||||||||||||||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| N3:N6 | N3 | =SUM(D3:M3) |
| Q5 | Q5 | =MIN('Analyse Transactions'!C:C) |
| Q6 | Q6 | =MAX('Analyse Transactions'!C:C) |
