Xisaabinta Blank ama Unugyada Bannaanka ee Excel

Excel Function COUNTBLANK

Excel wuxuu leeyahay tiro Tirooyin Tirooyin ah oo loo isticmaali karo in lagu tiriyo tirada unugyada ee kala duwan oo ay ku jiraan nooc gaar ah oo xog ah.

Shaqada COUNTBLANK ayaa ah in la tiriyo tirada unugyada kala duwan ee la kala doortay kuwaas oo ah:

• Faaruq - unugyo oo aan lahayn macluumaad
• Baqshiinka - unugyada ku jira qaaciddada oo soo celiya qiimaha bilaashka ah ama null

Ereyga iyo Iskuduwaha

Tusaalaynta 'function' waxaa loola jeedaa qaab-dhismeedka shaqada waxaana ka mid ah magaca shaqada, garsoorka, kala-goynta, iyo doodda .

Ereyga loogu talagalay shaqada COUNTBLANK waa:

= COUNTBLANK (Range)

Tirada (loo baahan yahay) waa kooxda unugyada shaqadu tahay inay raadiso.

Ogeysiis:

• Doodda Range waa inay noqotaa koox unugyo ah.
• Maadaama COUNTBLANK aysan oggolaanin kala duwanaansho kala duwan ee loo galo doodaha Range , marar badan oo hawlgalka ah ayaa lagu qori karaa hal caanood si loo helo tirada unugyada madhan ama faaruq ah ee laba ama in ka badan oo aan kala go 'lahayn, sida ku cad sadarka 3 ee tusaalaha kor ku xusan:
  • = COUNTBLANK (A2: A10) + COUNTBLANK (B2: B10)

Tusaale

Sawirka kor ku xusan, qaabab badan oo leh qaabka COUNTBLANK ayaa loo isticmaalaa in lagu tiriyo tirada unugyada madhan ama faaruq ah laba nooc oo xog ah: A2 ilaa A10 iyo B2 ilaa B10.

Galitaanka Functiona COUNTBLANK

Fursadaha lagu galo ficilka iyo doodaha waxaa ka mid ah:

1. Ku qorida howl dhammeystiran oo kor kuxusan oo ku jirta unug shaqo wareysi;
2. Xulashada shaqada iyo doodaheeda iyadoo la adeegsanayo sanduuqa xiriirka COUNTBLANK

Inkasta oo ay suurtagal tahay in kaliya lagu qoro shaqada dhamaystiran ee gacanta, dad badan ayaa u sahlan in ay isticmaalaan sanduuqa wada-hadalka oo eegaya ka dib marka la galo eray-saxda ah ee shaqada.

Fiiro gaar ah: Noocyo badan oo ka mid ah dhacdooyinka COUNTBLANK, sida kuwa lagu arkay safarka saddex iyo afar ka mid ah sawirka, laguma saari karo isticmaalka sanduuqa wada shaqeynta, laakiin waa in la galaa gacanta.

Tallaabooyinka hoose ee daboolaya gelitaanka COUNTBLANK ee lagu muujiyay unugta D2 ee sawirka kore iyadoo la adeegsanayo sanduuqa wada shaqeynta.

Si aad u furto sanduuqa COUNTBLANK Function Dialog Box

1. Riix batoonka D2 si aad u sameysid unug firfircoon - tani waa meesha natiijooyinka ficilka la soo bandhigi doono;
2. Riix shaxanka mawduuca ee salaanka ;
3. Click on Functions More> Tirakoobka si loo furo liiska hoos u dhaca shaqada;
4. Riix COUNTBLANK liiska si aad u keento sanduuqa wada shaqeynta;
5. Riix khadadka Range ee sanduuqa wada-hadalka;
6. Nuqulada A2 illaa A10 ee waraaqda shaqada si ay u galaan tixraacyada sida doodda Range ;
7. Guji OK si aad u dhammaystirto shaqada oo aad ku soo celiso waraaqda shaqada;
8. Jawaabta "3" waxay ka muuqanaysaa unugyada C3 maxaa yeelay waxaa jira saddex unugyo unugyo ah (A5, A7, iyo A9) ee A ilaa A10.
9. Markaad gujiso E1 qaybta dhammaystiran = COUNTBLANK (A2: A10) waxay u muuqataa in qaabka qaacida ee ka sarreeya waraaqda shaqada.

COUNTBLANK Hababka Kale

Waxyaabaha loo adeegsado COUNTBLANK ee loo isticmaali karo waxaa ka mid ah kuwa lagu muujiyay shan ilaa todoba sawirka kore.

Tusaale ahaan, qaaciddada safka shanaad, = COUNTIF (A2: A10, "") , wuxuu adeegsadaa howlaha COUNTIF si loo helo tirada unugyada madhan ama faaruq ah ee A2 illaa A10 waxayna keenaysaa natiijooyin isku mid ah COUNTBLANK.

Qaaciddooyinka safka lixda iyo todoba, dhanka kale, waxay helayaan unugyo madhan ama faaruq ah oo kala duwan oo kala duwan oo kaliya tiriya unugyada la kulma labada xaaladood. Noocyadaasi waxay bixiyaan dabacsanaan dheeraad ah oo ah waxa unugyada bilaashka ah ama nadiifka ah ee tiradooda lagu tiriyo.

Tusaale ahaan, qaaciddada safka lixaad, = QAYBTA (A2: A10, "", B2: B10, "") , wuxuu adeegsadaa COUNTIFS si loo helo unugyo madhan ama faaruq ah oo kala duwan oo kala duwan oo kaliya ayaa tiriya unugyada unugyada furan ee safka isku midka ah ee labadaba-xabbo.

Foomka kuxiran todoba, = SUMPRODUCT ((A2: A10 = "muuska") * (B2: B10 = "") , wuxuu adeegsanayaa SUMPRODUCT waxqabadka si loo tiriyo unugyada kala duwan ee kala duwan ee la kulma labada xaaladood-ku jira mooska inta ugu horeysa (A2 illaa A10) oo ah mid madhan ama faaruq ah oo ka baxsan heerka labaad (B2 ilaa B10).