Haddii aad haysato xaashi faafin^{(spreadsheet)} oo ay ku jiraan kaydka dukaanka ama wax la mid ah, oo aad u baahan tahay inaad tiriso qiimayaasha kala-saaran hal unug, halkan waa sida aad ku heli karto shaqada. Waxaa jira hawl fudud oo aad isticmaali karto si aad u geliso tirada dhammaan qiimayaasha kala-saaran hal unug iyada oo aan wax shaqo ah gacanta lagu qaban.

Aynu ka soo qaadno in qof kuu soo diray xaashida xaashida ah ee ay ka midka yihiin alaabooyinka, qiimaha, iwm. Waxaad u baahan tahay inaad samaysato tiir cusub oo aad ku xusto inta alaab ee ku soo gaadhay si aad wax u nadiifiso. Waqtiyadan oo kale, waxaad isticmaali kartaa hagahan.

Tiri^(Count) tirada qiimayaasha kala-saaray hal unug

Si aad u tiriso tirada qiimayaasha kala-saaran hal unug ee Excel & Google Sheets , waxaad u baahan tahay inaad raacdo tillaabooyinkan si aad u tiriso qiimaha hal unug-

1. Ku fur xaashida xaashida ee Excel ama Google Sheets
2. Dooro unug oo geli shaqo

Tilmaamaha faahfaahsan ayaa lagu xusay hoos.

Waxaa jira shaqo fudud oo qabta shaqada daqiiqado gudahood. Looma baahna in qalab lagu rakibo ama lagaa caawiyo adeeg dhinac saddexaad ah ama software.

Waxaad u baahan tahay inaad furto xaashida. Waxaad isticmaali kartaa Microsoft Excel ama Google Sheets si aad taas u sameyso. Taas ka dib, dooro unug meesha aad rabto inaad ku muujiso tirada dhammaan qiimayaasha kala go'ay.

Ka dib, isticmaal shaqada soo socota-

=LEN(TRIM(A1))-LEN(SUBSTITUTE(TRIM(A1),",",""))+1

Fadlan^(Please) ogow in shaqada aan kor ku soo xusnay ay muujinayso tirada dhammaan shayada kala go'ay ee unugga A1. Waxaad u baahan tahay inaad beddesho lambarka gacanta si aad u tiriso shayada unug kale.

Inkasta oo qaabkani uu si habsami leh ugu shaqeeyo Excel iyo Google Sheets , waxaa jira cillad. Waxaad u baahan tahay inaad beddesho lambarka gacanta mar kasta. Taasi waa sababta isticmaalka shaqadan ay waqti badan u qaadaneyso. Si kastaba ha noqotee, haddii aad leedahay toban ama labaatan saf, waxaad isticmaali kartaa qaacidadan si aad shaqadaada u dhameysato.

Count comma separated values in a single cell in Excel and Google Sheets

If you have a spreadsheet containing the stocks in a shop or something similar, and you need to count the comma-separated values in a single cell, here is how you can get the job done. There is a simple function that you can use to put the number of all comma-separated values in a single cell without any manual work.

Let’s assume that someone has sent you a spreadsheet which has items like products, price, etc. You need to make a new column to mention how many products have reached you so that you can clear things up. For such times, you can use this guide.

Count number of comma-separated values in a single cell

To count the number of comma-separated values in a single cell in Excel & Google Sheets, you need to follow these steps to count the value in a single cell-

1. Open spreadsheet with Excel or Google Sheets
2. Select a cell and enter a function

The detailed guide is mentioned below.

There is a simple function that does the job within moments. There is no need to install a tool or take help from any third-party service or software.

You need to open the spreadsheet. You can use Microsoft Excel or Google Sheets to do that. After that, select a cell where you want to display the number of all comma separated values.

Then, use the following function-

=LEN(TRIM(A1))-LEN(SUBSTITUTE(TRIM(A1),",",""))+1

Please note that the function mentioned above would display the number of all comma separated items of A1 cell. You need to change the cell number to count the items of a different cell.

Although this formula works smoothly in Excel and Google Sheets, there is a drawback. You need to change the cell number every time. That is why using this function is quite time-consuming. However, if you have only ten or twenty rows, you can use this formula to get your job done.

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

• Sida loo daabaco unugyada la doortay ee Excel ama Google Sheets hal bog

• Google Sheets vs Microsoft Excel - Waa maxay faraqa u dhexeeya?

• Sida loo abuuro Shaxda Radar gudaha Windows 11/10

• Sida loo beddelo Kiiska qoraalka ee Word iyo Google Sheets

• Wax-soo-saarka ugu fiican ee Google Sheets si loo horumariyo wax soo saarka

• U samee xiriir toos ah Google Sheets PDF isku xirka Google Drive

• Sida loo qariyo xaashiyaha, unugyada, tiirarka, iyo qaaciidooyinka gudaha Excel

• Sida otomaatig loogu sameeyo hawlaha xaashida Google ee Macros

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

• Sida loogu isticmaalo Habka Madow gudaha Google Docs, Sheets, iyo Slides

• Sida loo isticmaalo Percentile.Exc function gudaha Excel

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

• Sida loo dayactiro buug-shaqeedka Excel ee xumaaday

• Sida loo xidho unugyada qaacidada Excel si loo ilaaliyo

• 4 siyaabood oo Excel loogu badalo Google Sheets