Isixhumanisi se-3D ku-Excel

Isixhumanisi se-3D ku-Excel sibhekisela kuseli efanayo noma ububanzi obukumashidi amaningi ngesikhathi esisodwa. Ake siqale ngenye indlela:

1. 1. Eshidini elithi “Inkampani”, khetha iseli B2 bese ufaka uphawu olulinganayo “=".

1. Iya eshidini elithi “North”, khetha iseli B2 bese ufaka u-“+”.
2. Phinda isinyathelo sesi-2 eshidini elithi “Mid” kanye “South”. Umphumela:
3. Vuma, mningi umsebenzi. Ingasetshenziswa esikhundleni sokuphikisa umsebenzi ISUM (SUM) isixhumanisi esilandelayo se-3D: Enyakatho:Ningizimu!B2.

   =SUM(North:South!B2)

   =СУММ(North:South!B2)

   

4. Uma wengeza elinye ishidi phakathi “kweNyakatho” kanye “neNingizimu”, lizofaka ifomula ngokuzenzakalelayo: