Hi Telyn,
It was a typo on my part when I created the range names. I forgot a $ in front of one of the numbers for the absolute reference. It confused me because it worked for the first row and not any of the others. Now the formula works on all rows. So thank you very much for that because I learned a whole lot from just trying to understand that formula.
Now I'm trying to figure out how times I had 24 calls going on at once.
So the criteria for this formula seems to be.
1. Call_X overlaps with at least 24 calls and at least the 23 calls immediately after Call_X all overlap with at least 24 calls.
=COUNTIF(C2:C25>24)
And then copy that down? Seems like there should be something simple to calculate this, since the hard work has been done already. Still thinking this through but wanted to update you at least.
Thank you very much and have a great weekend.
Bookmarks