• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Rolling 6 month point removal

I have below formula in which I believe it will take a point of after 181 days. So basically if someone got a point on January 2nd the point should come off July 3rd correct? I don't see the points coming off. Can anyone help.

=IF(MIN(SUMIFS(H2:NH2,$H$1:$NH$1,">="&EDATE(TODAY(),-181),H2:NH2,"<="&TODAY()))=0,"",MIN(SUMIFS(H2:NH2,$H$1:$NH$1,">="&EDATE(TODAY(),-181),H2:NH2,"<="&TODAY())))
 

Attachments

  • Book2.xlsx
    45.8 KB · Views: 6
Hi ,

I don't have a clue about your points coming off , but looking at the formula you have posted , I think it should be :

=IF(MIN(SUMIFS(G2:NG2,$G$1:$NG$1,">="&EDATE(TODAY(),-181),G1:NG1,"<="&TODAY()))=0,"",MIN(SUMIFS(G2:NG2,$G$1:$NG$1,">="&EDATE(TODAY(),-181),G1:NG1,"<="&TODAY())))

The syntax of the SUMIFS function is :

SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], …)

so if G2:NG2 is the sum_range , then the criteria_range should be $G$1:$NG$1.

Narayan
 
Back
Top