Example:

I have 1 table with a column of numbers and dates.

I want to sum the numbers in a separate table, *and* sum the numbers of a filtered view [from the original table] in a 3rd table.

Is my only option creating views of the original table, applying the filter and then call the formula to lookup the data from the filter view?

This creates clutter with a need for multiple “tables” that are in fact views of 1 master table.

Would I use the IF function in the formula to apply the filter *and then* do the sum??

ie: IF(date=today,sum(X:X),"") something like this