Hononga 3D i Excel

Ko te hono 3D i Excel e tohu ana ki te pūtau kotahi, ki te awhe ranei i runga i nga rau maha i te wa kotahi. Me timata ma te rereke:

1. 1. I runga i te pepa "Kamupene", tohua te pūtau B2 ka tomo i te tohu rite “=”.

1. Haere ki te rau "Te Tai Tokerau", tohua te pūtau B2 ka tomo "+".
2. Whakahokia te taahiraa 2 mo te pepa "Waenganui" me "Te Tonga". Hua:
3. Whakaae, he nui te mahi. Ka taea te whakamahi hei tohenga ki tetahi mahi Tuhinga (SUM) te hono 3D e whai ake nei: Te Taitokerau:Te Tonga!B2.

   =SUM(North:South!B2)

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

   

4. Mena ka taapirihia e koe tetahi atu rau i waenga i te "Te Tai Tokerau" me te "Te Tonga", ka uru aunoa ki te tauira: