Como aplicar un sumar por categorías de una tabla y que el resultado alimente otra tabla

[Ismael1]

Como aplicar un equivalente a sumar.si en appshett?? Que formula usar por favor

[James_McFarlane]

Saludos Ismael,

Puedes intentar filtrando en el select o usando filter. Ve el link anexo.

SUM of Filter Data Questions

Hi I was helped by @Steve and he helped me write the expression to Filter data by Start date and End Date. I now have the data filtered as below IN( [Date], SELECT(Meter [Date], AND( [Date]>=ANY(DateFilter[Start Date]), [Date] <=ANY(DateFilter[End Date])))) Now I have Meter data (more than one meter) and there are 3 columns Meter[Oil], Meter[Water] and Meter[Gas] that I want to Aggregate or SUM for the chosen dates and only want Unique reading (1 reading) per Meter How do I achieve this? Th…