Points fall off after 365 days

[Caveman1964]

I am attempting to get absentee points to fall off after 365 days.
My sheet has a row with the date.
A row with the points.
I have it totaling the points in the row but want the points to not be included if its been 365 days.
My formula does not work...I have attempted multiple variations with no luck.
=SUM(IF(DATEDIF(J4:FLX4,J4:FLX4+J6:FLX6,"yd")<=365,J6:FLX6,0))

Row 4 is the date.
Row 6 is the points
Row 5 is simply the hours off and it isn't blank, it places the points into the day which is row 6.
a screen shot is to give some reference as to what I am referring to.
Any help is much appreciated!

 

[JGordon11]

try

SUM((today() - J4:FLX4<=365)*J6:FLX6)

 

[Caveman1964]

try

SUM((today() - J4:FLX4<=365)*J6:FLX6)

Ok just tried, def makes more sense but I'm getting the #value error. Let me check something.

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[Fluff]

How about

=sumifs(j6:flx6,j$4:flx$4,">="&today()-365

 

[Caveman1964]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

ah ok....thank you

 

[Caveman1964]

How about

=sumifs(j6:flx6,j$4:flx$4,">="&today()-365

YES! that worked!
Man I got excited..much appreciated...THANK YOU!

 

[Fluff]

Glad we could help & thanks for the feedback.
Thanks also for updating your profile