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

system automatically bumped March 13, 2021, 1:25pm #9

system automatically bumped April 4, 2021, 3:22am #10

system automatically bumped April 25, 2021, 5:18pm #11

system automatically bumped May 17, 2021, 1:12pm #12

system automatically bumped June 8, 2021, 7:08pm #13