I-Union and Intersect Ranges ku-Excel

Lesi sibonelo sibonisa indlela yokuthola inyunyana kanye nokuphambana kwezinhlanga ezimbili ku-Excel. Imingcele esithombeni esingezansi ingeyezinjongo zemifanekiso kuphela.

  1. Sebenzisa ikhoma ukuze uthole ukuhlangana kobubanzi obubili.Incazelo: Umsebenzi ISUM (SUM) yehliselwe ku

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

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

  2. Sebenzisa isikhala ukuze uthole ukuhlangana kobubanzi obubili.I-Union and Intersect Ranges ku-ExcelIncazelo: Umsebenzi ISUM (SUM) yehliselwe ku

    = SUM(D7:D8)

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

shiya impendulo