3D mahada a cikin Excel

Haɗin 3D a cikin Excel yana nufin tantanin halitta ɗaya ko kewayo akan zanen gado da yawa lokaci ɗaya. Bari mu fara da madadin:

1. 1. A kan takardar "Kamfani", zaɓi tantanin halitta B2 kuma shigar da alamar daidai "=".

1. Je zuwa takardar "Arewa", zaɓi tantanin halitta B2 kuma shigar da "+".
2. Maimaita mataki na 2 don takardar "Mid" da "Kudu". Sakamako:
3. Yarda, akwai aiki da yawa. Ana iya amfani dashi a maimakon haka azaman hujja ga aiki SUM (SUM) hanyar haɗin 3D mai zuwa: Arewa: Kudu! B2.

   =SUM(North:South!B2)

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

   

4. Idan ka ƙara wani takarda tsakanin "Arewa" da "Kudu", za ta shigar da dabara ta atomatik: