=somme.si.ens

Hello,

Is-it possible or not to dot this directly in the DataSource ?

=SOMME.SI.ENS(‘Page1’!F:F;‘Page1’!A:A;A98)

Thank a lot

Are you wanting to do the equivalent of a SUMIFS in the Glide Data Editor?

This is possible, and there are a few different ways to do it, but essentially it boils down to two steps:

  • Firstly, create a filter that only returns the rows that meet your criteria
  • Secondly, use a Rollup column to take a sum of the values in the result of the filtered rows

If you could provide a sample of your data and describe the desired result, we can probably provide some more specific guidance.

2 Likes