SUM values of column

[DaGi07]

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!!

[Marc_Dillon · Accepted solution]

help.appsheet.com

SELECT()

Gather column values from row in table or slice

help.appsheet.com

SUM()

Arithmetic sum of list items

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 ) +
  ...
)

[DaGi07]

THANKS SO MUCH MARC_DILLON!