3D njikọ na Excel

Njikọ 3D na Excel na-ezo aka na otu cell ma ọ bụ nso na ọtụtụ mpempe akwụkwọ ozugbo. Ka anyị jiri ụzọ ọzọ malite:

1. 1. Na mpempe akwụkwọ "Company", họrọ cell B2 ma tinye akara nhata "=".

1. Gaa na mpempe akwụkwọ "North", họrọ cell B2 ma tinye "+".
2. Tinyegharịa nzọụkwụ 2 maka mpempe akwụkwọ "Mid" na "South". Nsonaazụ:
3. Kwere, enwere ọtụtụ ọrụ. Enwere ike iji kama dịka arụmụka maka ọrụ SUM (SUM) njikọ 3D ndị a: Ugwu: Ndịda!B2.

   =SUM(North:South!B2)

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

   

4. Ọ bụrụ na ị gbakwunye mpempe akwụkwọ ọzọ n'etiti "North" na "South", ọ ga-abanye na-akpaghị aka: