[SOLVED] Help with a Sum/Filter formula

Hello! Im trying to get the sum of calories from the classes table where the month == < a certain month> … Anyone know what Im doing wrong here?

Thx!

@vivianc

See if this works (I didn’t test it).

Classes.Filter(Month = thisRow.Month).Calories.Sum()

It might be better to make Classes.Month a Lookup column to [Table 2].

Then your formula would read like this:
Classes.Filter(Month = thisRow).Calories.Sum()

Hey Ander! I tried the initial formula you provided and it worked. Thank you so much!! I had tried so many different things :smiley:

1 Like