I am using this formula to calculate a column of numbers that are both negative and positive numbers.
=SUMPRODUCT(--($A$5:$A$9647<=TODAY()),--($A$5:$A$9647>TODAY()-365),$C$5:$C$9647)
I need to keep this formula the same where it will calcuate on a rolling 365 day but I need the total to be only the absolute value (abs).
I appreciate any help updating this formula for this.
Thanks,
Nick
Bookmarks