Close
excel_logo

3.3.2. 3D-bog’lanish

Excelda 3D-bog’lanish bir nechta ish varaqlaridagi (Sheets, Листы) bir xil katak yoki sohaga bog’lanadi. Buni qanday qilishni ko’rishdan avval, uning muqobilini ko’rib chiqamiz.

1.“Company” ish varag’ida, B2 katakni tanlang, va barobar (=) belgisini kiriting.

alternative-step1

2. “North” ish vaqag’iga boring, B2 katakni tanlang va qo’shuv (+) ni yozing.

2

3. “Mid” va “South” ish varaqlari uchun 2-qadamni takrorlang.

Natija.

3

4. Bu anchagina ko’p ish. Buning o’rniga, SUM (СУММ) funksiyasiga argument sifatida quyidagi 3D-bog’lanishdan foydalaning: North:South!B2

Formula quyidagi ko’rinishda bo’ladi: =SUM(North:South!B2) yoki =СУММ(North:South!B2)

3d-reference_5

5. “North” va “South” ish varaqlarining orasiga yangi ish varag’i qo’shsangiz, u avtomatik tarzda B2 katakdagi formulani ichiga kiradi.

3d-reference_5

(34 marta o'qilgan, bugun 1 marta o'qildi)

O'xshash maqolalar:

Leave a Reply

Your email address will not be published. Required fields are marked *