I have been bumping my head against a formula for a few hours now, I can't seem to fully understand how it works.
It's the formulas in Sheet2 that are used to determine the number of 2-0, 2-1, 0-2 1-2 set scores.
So from what I saw, SUMPRODUCT will multiply the values in two(in this case) arrays and then sum the products. But in this case I can't understand what exactly is the second array
I think that the first part of the formula says array1 = "only take into consideration the instances where in the arrays Sheet1!$O$1:$O$468 and Sheet1!$L$1:$L$468 both have the value "selected player and" "2-0" respectively, if true, value is 1 , if false value is 0
But with array 2, I can't understand how the SUBTOTAL works in this case, especially in conjunction with the SUMPRODUCT
So if anyone can help me "translate" or explain the second part of the formula into plain English, would be great. Hopefully I at least understood the first part.
And also I hope my question isn't too confusing.
Bookmarks