I'm using an array function to calculate the number of overlapping days in a vertical set of date ranges, but i want to separate the counting of overlapping days based on a value in column A of each row (i.e., still compare the date in a row to all of the other dates in the spreadsheet to see if there is overlap, but total the overlap in two sets based on the two possible values in column A). Alternatively, i could use an array function that gives overlap values by row and then use a sumif function, but only if i can figure out how to not double count overlapped days.
Solved by K. Q. in 30 mins