Union da Intersect Ranges a cikin Excel

Wannan misalin yana nuna yadda ake samun haɗin gwiwa da haɗin kai na jeri biyu a cikin Excel. Iyakoki a cikin hoton da ke ƙasa don dalilai ne kawai.

1. Yi amfani da waƙafi don samun haɗin kan jeri biyu.Ƙarin bayani: aiki SUM (SUM) an rage zuwa

   = SUM(C4:D8) + SUM(D7:E11)

   = СУММ(C4:D8) + СУММ(D7:E11), т.е. 20.

2. Yi amfani da sarari don samun hanyar haɗin kewayo biyu.Ƙarin bayani: aiki SUM (SUM) an rage zuwa

   = SUM(D7:D8)

   = СУММ(D7:D8), т.е. 2.