Liiska, waxa laga yaabaa inaad u baahato inaad tiriso tirada Haa^(Yes) iyo Maya. Maqaalkani waxa uu ka hadlayaa sida loo tiriyo tirada jawaabaha " Haa^(Yes) " ama "Maya" ee Excel . Tirintan oo kale waxay ku caawin kartaa helida tirada la soo galiyay ee la doortay ama la diiday.

Sida loo tiriyo lambarka Haa^(Yes) ama Maya ee Excel

Tusaale ahaan, haddii aad go'aansanayso tirada ciyaartoyga loo doortay (ama la diiday) dhacdo ama tirada badeecadaha la doortay ama loo diiday dhoofinta, xisaabintani waxay noqon kartaa mid faa'iido leh.

Waxaan u isticmaali doonaa shaqada COUNTIF si aan u kala saarno tirinta. Tani kuma koobna Haa^(Yes) ama Maya, laakiin qiime kasta oo soo noqnoqda ee tiirka.

Tiri^(Count) lambarka " Haa^(Yes) " ama "Maya" gelitaanka Excel

Isku dhafka shaqada COUNTIF si loo helo tirada soo celinta soo noqnoqda ee tiirka waa sida soo socota:

=COUNTIF(<first cell>:<last cell>,"<repetitive entry>")

Halkee,

• <first cell> waa unugga ugu horreeya ee tiirka gelintaada kaas oo aad uga baahan tahay inaad xisaabiso tirada soo-celinta soo noqnoqda.
• <last cell> waa unugga ugu horreeya ee tiirka gelintaada kaas oo aad uga baahan tahay inaad xisaabiso tirada soo-celinta soo noqnoqda.
• <repetitive entry> waa weedha saxda ah, xarafka, nambarka, ama astaanta gelitaanka soo noqnoqda ee aad u baahan tahay in lagu tiriyo. Waxay noqon kartaa Haa^(Yes) , maya, 1, 0, la diiday, la doortay, ama wax kasta.

Tusaale ahaan. Haddii aad u baahan tahay inaad tiriso tirada Haa^(Yes) iyo Maya liiska 10 qof, sida gelitaanka Haa^(Yes) iyo Maya lagu dhejiyo Tiirka C^{(Column C)} laga bilaabo C4 ilaa C13 , qaacidada tirinta Haa^(Yes) gelitaanka waxay noqon doontaa:

=COUNTIF(C4:C13,"Yes")

Iyo qaacidada tirinta Wax gelitaanku waxay noqonaysaa:

=COUNTIF(C4:C13,"No")

Geli^(Enter) qaacidooyinkan unugyada halka aad u baahan tahay natiijada la rabo.

Tiri^(Count) tirada gelitaannada aan ka ahayn " Haa^(Yes) " ama "Maya" ee Excel

Haddii aad rabto inaad hubiso tirinta liiska liiska ku jira tiir aan ahayn 2da shay ee la doortay, qaacidadu waxay noqonaysaa:

=COUNTA(<first cell>:<last cell>)-COUNTIF(<first cell>:<last cell>,"<first entry>")-COUNTIF(<first cell>:<last cell>,"<second entry>")-COUNTIF(<first cell>:<last cell>,"=""")

Halkee,

• <first cell> waa unugga ugu horreeya ee tiirka gelintaada kaas oo aad uga baahan tahay inaad xisaabiso tirada soo-celinta soo noqnoqda.
• <last cell> waa unugga ugu horreeya ee tiirka gelintaada kaas oo aad uga baahan tahay inaad xisaabiso tirada soo-celinta soo noqnoqda.
• <first entry> waa erayga ugu horreeya ee soo noqnoqda iyo <second entry> waa ereyga labaad ee soo noqnoqda.

Xaaladda kor ku xusan, iyada oo loo maleynayo in unugga koowaad ee tiirka C uu yahay C4, unugga ugu dambeeya waa C13 , gelitaanka koowaad waa Haa^(Yes) iyo gelitaanka labaadna waa Maya, qaaciddadu waxay noqon doontaa:

=COUNTA(C4:C13)-COUNTIF(C4:C13,"Yes")-COUNTIF(C4:C13,"No")-COUNTIF(C4:C13,"=""")

Rajo inay ku caawiso!

Hadda akhri^{(Now read)} : Sida Unugyada Banaan looga saaro xaashida Microsoft Excel .

How to count number of Yes or No entries in Excel

In a list, you might need to count the number of Yes and No entries. This article discusses how to cоunt the number of “Yes” or “No” answers in Excel. Such a count could be helpful in fіnding the number оf entries selected or rejectеd.

How to count number of Yes or No entries in Excel

As an example, if you are deciding upon the number of sportspersons selected (or rejected) for an event or the number of products approved selected or rejected for export, this calculation can be useful.

We will use the COUNTIF function to sort the count. This isn’t limited to Yes or No, but any repeated value across a column.

Count number of “Yes” or “No” entries in Excel

The syntax for the COUNTIF function for finding the number of repetitive entries across a column is as follows:

=COUNTIF(<first cell>:<last cell>,"<repetitive entry>")

Where,

• <first cell> is the first cell in the column of entries from which you need to calculate the number of repetitive entries.
• <last cell> is the first cell in the column of entries from which you need to calculate the number of repetitive entries.
• <repetitive entry> is the exact phrase, letter, number, or symbol of the repetitive entry that you need to be counted. It could be Yes, No, 1, 0, Rejected, Selected, or anything.

Eg. If you need to count the number of Yes and No entries for a list of 10 people, such that the Yes and No entries are placed in Column C from C4 to C13, the formula for the count of Yes entries would become:

=COUNTIF(C4:C13,"Yes")

And for the formula for the count of No entries would become:

=COUNTIF(C4:C13,"No")

Enter these formulae in the cells where you need the desired result.

Count number of entries other than “Yes” or “No” in Excel

If you wish to check the count of the entries in a list across a column other than the 2 selected entries, the formula would become:

=COUNTA(<first cell>:<last cell>)-COUNTIF(<first cell>:<last cell>,"<first entry>")-COUNTIF(<first cell>:<last cell>,"<second entry>")-COUNTIF(<first cell>:<last cell>,"=""")

Where,

• <first cell> is the first cell in the column of entries from which you need to calculate the number of repetitive entries.
• <last cell> is the first cell in the column of entries from which you need to calculate the number of repetitive entries.
• <first entry> is the first repetitive word and <second entry> is the second repetitive word.

In the case mentioned above, assuming that the first cell in column C is C4, the last cell is C13, the first entry is Yes and the second entry is No, the formula would become:

=COUNTA(C4:C13)-COUNTIF(C4:C13,"Yes")-COUNTIF(C4:C13,"No")-COUNTIF(C4:C13,"=""")

Hope it helps!

Now read: How to remove Blank Cells from a Microsoft Excel spreadsheet.

Related posts

• Sida loo isticmaalo Percentile.Exc function gudaha Excel

• Sida loo isticmaalo shaqada NETWORKDAYS gudaha Excel

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

• Sida loo isticmaalo sifada Nooca Xogta tooska ah ee Excel

• Sida loo abuuro Shaxda Radar gudaha Windows 11/10

• Sida loogu daro Trendline xaashida shaqada ee Microsoft Excel

• Sida loo isticmaalo shaqada COOSE ee Excel

• Sida loogu daro Koodhka Dalka ama Goobta Liiska Lambarka Taleefanka ee Excel

• Sida loo abuuro oo loo isticmaalo Koontaroolada Foomka gudaha Excel

• Sida loo isticmaalo Muddada Dhaqaale Function gudaha Excel

• Sida loo qoro, loo dhiso, loona isticmaalo shaqada VLOOKUP gudaha Excel

• U beddelo CSV una beddelo Excel (XLS ama XLSX) adoo isticmaalaya khadka taliska ee Windows

• Sida loogu isticmaalo shaqada MID iyo MIDB gudaha Microsoft Excel

• Sida loo isticmaalo Rept Function gudaha Excel

• Sida loogu isticmaalo DEC2Bin gudaha Excel si loogu beddelo nambarka jajab tobanle ee binary

• Sida loo midoobo oo loo kala saaro unugyada Excel

• Sida loo beddelo midabka warqadda shaqada ee Excel

• Sida loo dayactiro buug-shaqeedka Excel ee xumaaday

• Sida loo geliyo oo loo xisaabiyo foomamka iyo shaqooyinka Excel

• Sida loo bilaabo Word, Excel, PowerPoint, Outlook in Mode Safe