3D txuas hauv Excel

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:

    1. Hauv daim ntawv "Company", xaiv lub cell B2 thiab sau qhov sib npaug kos npe “=”.
  1. Mus rau daim ntawv "North", xaiv lub cell B2 thiab sau "+".3D txuas hauv Excel
  2. Rov ua kauj ruam 2 rau daim ntawv "Nruab nrab" thiab "South". Qhov tshwm sim:3D txuas hauv Excel
  3. 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)

    3D txuas hauv Excel

  4. Yog tias koj ntxiv lwm daim ntawv ntawm "North" thiab "South", nws yuav nkag mus rau cov qauv:3D txuas hauv Excel

Sau ntawv cia Ncua