Traditional Culture Encyclopedia - Photography and portraiture - =SUM(SUMIFS(F3:F24, B3:B24, {"Wuhan", "Guangzhou"}, A3: a24, {"July"); August; "10 month"}) What are the functions of commas and semicolons in the formula?

=SUM(SUMIFS(F3:F24, B3:B24, {"Wuhan", "Guangzhou"}, A3: a24, {"July"); August; "10 month"}) What are the functions of commas and semicolons in the formula?

Commas are arrays of rows and semicolons are arrays of columns.

For example {1; 2; 3; 4} is a constant array with 4 rows 1 column, which is in the table.

1

2

three

four

{ 1,2; 3,4; 5,6} is a constant array with 3 rows and 2 columns.

1 3 5

2 4 6

The form of.