Trying to create a Countif formula that includes the # of workers allocated based on date range
I'd like to create a formula that would count all of the entries in a specific column (# of Workers Allocated) IF TODAY is within the date range that corresponds to each job entry (highlighted). As I've been tinkering with the formula, I can't quite seem to get it to return what I need. It gave me an answer of 4 (second picture), and I can't figure out why?
Thank you for any help considered!
Help Article Resources
Check out the Formula Handbook template!