Formula to encompass a week's worth of data

[Rick_Betori]

Edit*

I want to try a condensed formula because the SUM equation with all of these COUNTIFS makes my automation run incredibly slowly...it works just fine functionally, but I just want to optimize my automation.

Any help would be greatly appreciated!

 

[Rick_Betori]

PLEASE IGNORE THIS THREAD. I'm new to this forum and I made my attempt of a reply become a new thread