Union sy Intersect Ranges amin'ny 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.fanazavana: asa vola (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.fanazavana: asa vola (SUM) is reduced to

   = SUM(D7:D8)

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