Forum Discussion
Need Y'all's Help Again
I don't know it errored, just gave a long error, so I SSed what I typed and pasted it into the post.
Mr. m_tarler answer is a clever solution and frankly, it is much simpler than the complex SUMPRODUCT formula I mention here as an alternative approach…
Formula:
=SUMPRODUCT((AD25:AD29<>"") * (AE25:AE29<>"") *
(( (AD25:AD29 <= AE25:AE29) * (AD25:AD29 <= AD24) * (AE25:AE29 > AD24) )
+
( (AD25:AD29 > AE25:AE29) * ( (AD25:AD29 <= AD24) + (AE25:AE29 > AD24) ) )))
*There is one very important catch you need to watch out for:
Empty cells in your ranges (AD25:AD29, AE25:AE29, etc.) will be treated as 0 by Excel.