Because the arrays have to be the same size for each of the sumproduct conditions, I am really just offsetting the ranges to keep the sizes the same... and because you have different alternating columns with same type of info, offsetting the range for the dates gets the right data in line in order to compare properly after Sumproduct has created the TRUE/FALSE resultant arrays.

Not sure what you mean by the 2nd question... can you give example of what you mean?