Iuni ma Feso'ota'iga Va'aiga i Excel

This example shows how to get the union and intersection of two ranges in Excel. The borders in the figure below are for illustrative purposes only.

  1. Use a comma to get the union of two ranges.Faamatalaga: galuega tauave SUM (SUM) is reduced to

    = SUM(C4:D8) + SUM(D7:E11)

    = СУММ(C4:D8) + СУММ(D7:E11), т.е. 20.

  2. Use a space to get the intersection of two ranges.Iuni ma Feso'ota'iga Va'aiga i ExcelFaamatalaga: galuega tauave SUM (SUM) is reduced to

    = SUM(D7:D8)

    = СУММ(D7:D8), т.е. 2.

Tuua se tali