CODEWITHSUNDEEP
excelexcel-formulaexcel-2010excel-2007
Jason Lucas
Jason Lucas

Reputation: 113

Last 7 day with Open Status

I have a ticket system tracker excel sheet that I use every day. I'm looking to get the number of tickets opened in the last 7 days. Column G shows if the ticket is "Closed or Open" Column C shows the date of submission of the ticket. I want to be able to verify ticket is open and then count how many are still open in the last 7 days. I have it somewhat pieced together but not totally working. Any help would be appreciated

=COUNTIFS(Main!G:G,"Open",Main!C:C,"<"&TODAY()+1,Main!C:C,">="&TODAY()-7)

Upvotes: 0

Views: 159

Answers (1)

Jason Lucas
Jason Lucas

Reputation: 113

=SUMPRODUCT((Main!G:G="Open")*(Main!C:C<TODAY()+1)*(Main!C:C>=&TODAY()-7))

Upvotes: 0

Related Questions