Microsoft Excel iyo Google Sheets waxay taageeraan hawlo aan la tirin karin si dadka isticmaala ay u qabtaan shaqooyin kala duwan. Waxaa jira qaar ka mid ah hawlaha loo yaqaan COUNTBLANK , COUNTIF , SUMPRODUCT , iwm kuwaas oo kaa caawin doona inaad tiriso unugyo madhan ama madhan. ^{(count blank or empty cells. )}Mararka qaarkood, waxa laga yaabaa inaad u baahato inaad xisaabiso dhammaan unugyada madhan xaashida. Haddii ay leedahay laba ama saddex tiir iyo toban ama labaatan saf, waxaad ku xisaabin kartaa gacanta. Si kastaba ha ahaatee, dhibaatadu waxay bilaabataa markaad tagto inaad tiriso unugga madhan ee xaashida weyn. Taasi waa marka aad isticmaali karto khiyaamadan si aad u hesho tirada saxda ah ee unugyada maran ee Google Sheets ama Excel .

Ku tiri^(Count) unugyo madhan ama madhan Excel ama Google Sheets

Si aad u tiriso unugyo madhan ama madhan Google Sheets iyo Excel , raac talaabooyinkan-

1. Ku fur xaashida xaashida Google^{(Google Sheets)} -ka ama Excel .
2. Isticmaal^{(Use COUNTBLANK)} COUNTBLANK , COUNTIF ama SUMPRODUCT

Marka hore, waxaad u baahan tahay inaad ku furto xaashida xaashida Google^{(Google Sheets)} -ka ama Microsoft Excel . Hadda waa inaad hoos u dhigtaa tiirarka / safafka aad rabto inaad u hesho tirada unugyada madhan. Waxay noqon kartaa hal ama dhowr tiir, waxayna kuxirantahay shuruudahaaga.

Intaa ka dib, dhagsii unug madhan oo xaashidaada ku jira halkaas oo aad rabto inaad ku muujiso lambarka. Kadibna, geli shaqo sidan oo kale ah-

=COUNTBLANK(A2:D5)

Shaqadan COUNTBLANK waxay tirisaa unugyo madhan inta u dhaxaysa A2 iyo D5. Waxaad bedeli kartaa tiirka/lambarka safka hadba baahidaada.

Waxaa jira shaqo kale oo qabta shaqo la mid ah sida COUNTBLANK . Waxaa loo yaqaan COUNTIF . Shaqadani waa mid anfacaya marka isticmaalayaashu ay u baahan yihiin inay tiriyaan unugyada ka kooban kelmad gaar ah ama lambar ama calaamad. Si kastaba ha ahaatee, waxaad isticmaali kartaa isla shaqada si aad u tiriso unugyada madhan ee Google Sheets iyo sidoo kale xaashida Microsoft Excel .

Si aad habkan u isticmaasho, waxaad u baahan tahay inaad furto xaashida faafinta, dooro unug, oo geli hawshan-

=COUNTIF(A2:D5,"")

Waxaad u baahan tahay inaad beddesho tirada sida waafaqsan shuruudahaaga. Shaqada COUNTIF^(COUNTIF) waxay u baahan tahay qiime u dhexeeya hakad rogan. Markaad raadinayso unugyo bannaan, looma baahna in la galo wax qiimo ah ama qoraal ah.

Shaqada saddexaad waa SUMPRODUCT . Inkasta oo ay aad uga duwan tahay shaqooyinka kale sababtoo ah sifooyinkeeda, waxaad ku heli doontaa shaqada adoo kaashanaya shaqada SUMPRODUCT .

Sida caadiga ah, waxaad u baahan tahay inaad doorato unug meesha aad rabto inaad ku muujiso lambarka oo geli shaqadan-

=SUMPRODUCT(--(A2:D5=""))

Waxaad u baahan tahay inaad beddesho kala duwanaanta ka hor inta aanad gelin hawshan oo ha ku qorin wax u dhexeeya hakadyada rogan.

Waxaan rajeyneynaa in casharradani ku caawinayo.^{(Hope this tutorial helps you.)}

How to count blank or empty cells in Excel and Google Sheets

Microsoft Excel and Google Sheets support countless functions so that users can perform various jobs. There are some functions called COUNTBLANK, COUNTIF, SUMPRODUCT, etc. that will help you to count blank or empty cells. Sometimes, you may need to count all empty cells in a spreadsheet. If it has two or three columns and ten or twenty rows, you can calculate them manually. However, the problem starts when you go to count the empty cell of a large spreadsheet. That is when you can use this trick to get the exact number of blank cells in Google Sheets or Excel.

Count blank or empty cells in Excel or Google Sheets

To count blank or empty cells in Google Sheets and Excel, follow these steps-

1. Open the spreadsheet in Google Sheets or Excel.
2. Use COUNTBLANK, COUNTIF or SUMPRODUCT function

First, you need to open the spreadsheet in Google Sheets or Microsoft Excel. Now you should note down the columns/rows for which you want to find the number of empty cells. It can be one or multiple columns, and it depends on your requirements.

After that, click on an empty cell in your spreadsheet where you want to display the number. Then, enter a function like this-

=COUNTBLANK(A2:D5)

This COUNTBLANK function counts empty cells between A2 and D5. You can change the column/row number as per your needs.

There is another function that does the same job as COUNTBLANK. It is called COUNTIF. This function is handy when users need to count cells containing a specific word or digit or symbol. However, you can use the same function to count the empty cells in Google Sheets as well as the Microsoft Excel spreadsheet.

To use this method, you need to open a spreadsheet, select a cell, and enter this function-

=COUNTIF(A2:D5,"")

You need to change the range according to your requirements. COUNTIF function requires a value between inverted commas. As you are going to find blank cells, there is no need to enter any value or text.

The third function is SUMPRODUCT. Although it is quite different from other functions because of its characteristics, you will get the job done with the help of SUMPRODUCT function.

As usual, you need to select a cell where you want to display the number and enter this function-

=SUMPRODUCT(--(A2:D5=""))

You need to change the range before entering this function and do not write anything between the inverted commas.

Hope this tutorial helps you.

Related posts

• Sida loo muujiyo Taariikhda iyo Waqtiga Hadda ee Excel iyo Google Sheets

• Sida loo sameeyo liiska hoos u dhaca ee Excel iyo Google Sheets

• Sida loogu xidho Google Sheets iyo Excel

• Sida loo sameeyo garaaf xariiq qaloocan gudaha Excel iyo Google Sheets

• Xaashiyaha Google ee ugu Fiican iyo Hababka Jadwalka Kalandarka ee Excel Online

• Excel, Word ama PowerPoint ma bilaabi karaan markii ugu dambeysay

• Sida loo abuuro oo loo isticmaalo Koontaroolada Foomka gudaha Excel

• Sida loo beddelo Kiiska qoraalka ee Word iyo Google Sheets

• Sida loo beddelo midabka warqadda shaqada ee Excel

• Sida otomaatig loogu sameeyo hawlaha xaashida Google ee Macros

• Samee qaab-dhismeedka xaashiyaha Google-ka adigoon Google-ka ku biirin goobta shaqada

• Sida faylka Excel loogu beddelo PDF onlayn addoo isticmaalaya Google Drive

• Sida loo isticmaalo Rept Function gudaha Excel

• Sidee si degdeg ah loogu duubaa qoraalka xaashida Google?

• Sida loo isticmaalo sifada Nooca Xogta tooska ah ee Excel

• Sida loo geliyo shaxda firfircoon ee xaashida Excel

• Sida loo abuuro Shaxda Radar gudaha Windows 11/10

• Sida qoraalka loogu beddelo abka shabakadda Google Sheets

• 5 Shaqooyinka Qoraalka Xaashiyaha Google ee aad u baahan tahay inaad ogaato

• Sida loo tiriyo lambarka Haa ama Maya ee Excel