3D link muExcel

A 3D link muExcel inoreva sero rimwechete kana renji pamapepa akawanda kamwechete. Ngatitange neimwe nzira:

1. 1. Papepa re "Company", sarudza sero B2 uye isa chiratidzo chakaenzana "="".

1. Enda kune "North" pepa, sarudza sero B2 uye isa "+".
2. Dzokorora danho rechipiri kune "Mid" uye "South" pepa. Mhedzisiro:
3. Bvumiranai, kune basa rakawanda. Inogona kushandiswa pachinzvimbo senharo kune basa SUM (SUM) iyi inotevera 3D link: Maodzanyemba:Maodzanyemba!B2.

   =SUM(North:South!B2)

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

   

4. Kana iwe ukawedzera rimwe pepa pakati pe "North" ne "Maodzanyemba", rinozongopinda fomula: