SUM values of column

Good morning to everyone!
I would like SUM the columns from E to N for each partner. In the file attached, i highlited in yellow the result that i’d like see in my app for Project Management in order to be clearer in my request.

Thanks to everyone who will answer me!!

You’ll have to specify each column individually, as Appsheet has no way to select across multiple columns. So your expression will be a bit large, but the individual parts will be fairly simple.

SUM(
  SELECT( table[E] , [partner] = XXX ) +
  SELECT( table[F] , [partner] = XXX ) +
  ...
)
2 Likes

THANKS SO MUCH MARC_DILLON! :wink:

1 Like