Total Sum for Previous Three Months

Sigma Formulas and Functions

ztrean October 26, 2020, 10:20pm #1

Can someone help me out with a total column formula for the sum of a column that will always only be the last three months?

Ryan October 26, 2020, 10:21pm #2

Hey Zachary!

Try using this formula:

SumIf([Column], DateDiff(“month”, [Date], Now()) <= 3)

system automatically bumped November 11, 2020, 9:49am #3

system automatically bumped December 1, 2020, 3:07am #4

system automatically bumped December 20, 2020, 5:21am #5

system automatically bumped January 9, 2021, 9:09am #6

system automatically bumped January 29, 2021, 5:37pm #7

system automatically bumped February 20, 2021, 3:24am #8