Additionner une colonne en fontion d'une autre

Bonjour,
j’ai deux colonnes la premiere “Chantier” et la deuxieme “heures journée”.
je souhaite faire la somme de la colonne “heures journée” pour tous les noms de chantier identique.
Example
Colonne chantier/ Colonne heure journée/ resultat
CH A / 8 / 11
CH B /4 /9
CH C / 2 /2
CH A / 3 /11
CH B /5 /9

Merci de votre aide,

3 Likes

Bonjour,

I believe you have three options with advantages/disadvantages as mentioned. Describing the options in detail as per my understanding because similar questions of summing rows are often there.

1) Add a Virtual Column called [resultat] : Easy to implement but expensive for app sync time and the sum value will not be stored in the spreadsheet.
Expression for [resultat]
SUM ( SELECT(Table Name[Colonne heure journée/], [Colonne chantier]=[_THISROW].[Colonne chantier]))
Please replace the table name with your table name.
2) Add a real column and spreadsheet formula: Will store the results in the spreadsheet but the [resultat] will update while adding a new record only after the latest record is saved. The sync time will be somewhat expensive. The spreadsheet formula for [resultat] column each row can be as below
SpreadSheet Formula

Please note the middle part of the formula (A2) will change to A3, A4 … for each row.

3) Use reference actions to update the real column. The implementation may be a bit cumbersome. The sync time may be consumed while adding record but it could be in the background. This option could be used if handful of records and not large number of records are to be updated, because each record will be updated by an action.
https://www.appsheet.com/samples/This-app-shows-how-to-use-reference-actions?appGuidString=e76d2e73-3d26-475c-a8f8-9911f5015920

2 Likes