SOLVED

Union intersect operator. "," (comma)

Contributor

Does anyone know if in EU and Indonesian versions of Excel, whether the Union intersect operator is a comma or ; (semi-colon).

Support.Microsoft.com, as usual, doesn't make a mention on the issue of how those versions have problems because of the use of the , (comma) for the decimal indicator. 

2 Replies
best response confirmed by Norman_Harker (Contributor)
Solution

@Norman_Harker 

If you use comma as decimal separator:

\ separates columns in an array

; separates rows in an array.

For example, ={1\2\3;4\5\6} results in

 

S0188.png

 

; is the union operator: =SUM(A1:A2;C2:D2) is the sum of A1, A2, C2 and D2.

space is the intersect operator: =SUM(D1:F1 E1:E2) is the sum of the cells in the intersection of D1:F1 and E1:E2 (i.e. cell E1).

Thanks Hans!
As I suspected there is a difference where a comma is the decimal separator.