Solved: SUM values of column

DaGi07 · 04-29-2021 04:29 AM

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

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

View solution in original post

Marc_Dillon

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!