Right. So you are basically multiplying 3 arrays, each of which resulted from each of the 3 conditions.
I guess I am just wondering why you could not just replace SUMPRODUCT with SUM, since you are really only 'feeding' it 1 array?
Right. So you are basically multiplying 3 arrays, each of which resulted from each of the 3 conditions.
I guess I am just wondering why you could not just replace SUMPRODUCT with SUM, since you are really only 'feeding' it 1 array?