I just discovered what I consider a major flaw in the design of the Union (comma) operator. As illustrated in the workbook here:
https://www.dropbox.com/sh/v0799qr2uex4imf/AAAWi4Jhq4-vfCmuQTn4qo4Za?dl=0
The Sum function, when applied to a union of overlapping ranges, will sum the values in the...