Migwirizano ndi Intersect Ranges mu Excel

Chitsanzochi chikuwonetsa momwe mungapezere mgwirizano ndi mphambano yamitundu iwiri mu Excel. Malire omwe ali pachithunzichi ndi ongowonetsera chabe.

  1. Gwiritsani ntchito koma kuti mupeze mgwirizano wamitundu iwiri.Kufotokozera: ntchito SUM (SUM) yachepetsedwa kukhala

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

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

  2. Gwiritsani ntchito danga kuti mupeze mphambano yamagulu awiri.Migwirizano ndi Intersect Ranges mu ExcelKufotokozera: ntchito SUM (SUM) yachepetsedwa kukhala

    = SUM(D7:D8)

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

Siyani Mumakonda