Ib qhov txuas 3D hauv Excel hais txog tib lub xov tooj lossis ntau yam ntawm ntau nplooj ntawv ib zaug. Cia peb pib nrog ib qho kev xaiv:
- Hauv daim ntawv "Company", xaiv lub cell B2 thiab sau qhov sib npaug kos npe “=”.
- Mus rau daim ntawv "North", xaiv lub cell B2 thiab sau "+".
- Rov ua kauj ruam 2 rau daim ntawv "Nruab nrab" thiab "South". Qhov tshwm sim:
- Pom zoo, muaj ntau txoj haujlwm. Yuav siv tau los ua kev sib cav rau ib qho haujlwm sum (SUM) 3D txuas hauv qab no: Sab Qab Teb: Sab Qab Teb! B2.
=SUM(North:South!B2)
=СУММ(North:South!B2)
- Yog tias koj ntxiv lwm daim ntawv ntawm "North" thiab "South", nws yuav nkag mus rau cov qauv: