3D ulalo mu Excel

Ulalo wa 3D mu Excel umatanthawuza selo lomwelo kapena mndandanda wamasamba angapo nthawi imodzi. Tiyeni tiyambe ndi njira ina:

1. 1. Patsamba la "Company", sankhani selo B2 ndipo lowetsani chizindikiro chofanana "="".

1. Pitani ku tsamba la "North", sankhani selo B2 ndi kulowa "+".
2. Bwerezani sitepe 2 pa pepala la "Mid" ndi "South". Zotsatira:
3. Gwirizanani, pali ntchito yambiri. Itha kugwiritsidwa ntchito ngati mtsutso ku ntchito SUM (SUM) ulalo wotsatira wa 3D: Kumpoto:Kummwera!B2.

   =SUM(North:South!B2)

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

   

4. Mukawonjezera pepala lina pakati pa "Kumpoto" ndi "Kumwera", lidzangolowetsamo: