Rorohiko, Pūmanawa
"COUNTIF" i roto i te Excel: Tauira Whakamārama
ngā tetahi o te tino pinepine upotrebimykh te tono ripanga kaha "Excel" i te kamupene "Microsoft" - te "COUNTIF". Te aha e mea e tika ana? He mārama i tona taitara kē te reira. E tauturu te reira i tetahi kaiwhakamahi ki te ui i te uiraa "Me pēhea te ki te tatau i te pūtau i roto i te Excel i runga i ngā paearu motuhake?", Ki te tiki i te tau tika.
tohenga taumahi
Tenei mahi e rua ngā tohenga e hiahiatia ana. Ko te tuatahi o ratou - he whānui i roto i nei ki te tatau i te maha o ngā pūtau e whakatau i te huru.
Ko te tautohe tuarua - he tu'unga e taea te whakaturia i roto i te puka o tau kupu ranei, me rite i roto i te puka o tikanga.
Ka rite mai tatou i te whānuitanga o ngā raraunga, me te titiro ki te pehea, ki te titiro hoki ngā āhuatanga motuhake "COUNTIF" i roto i te tauira Excel i runga i taua mea. Kia mea a to tatou he rārangi o hua me huawhenua i roto i te rokiroki ki te rārangi o ratou utu hoko, hoko tahua me te rā hoko. Haamata te mahi ki te tepu ki Excel - inaianei tango i runga i te raumahi te raraunga e whai ake nei:
He | Ko te | C | D | |
1 | Hua / Vegetables | utu Hoko (kg) | Tahua (%) | Rā o te hoko |
2 | aporo Gold | 74.5 | 28 | 05/01/2017 |
3 | aporo Fuji | 69.8 | 50 | 05/16/2017 |
4 | panana | 41 | 75 | 05/04/2017 |
5 | te panana paku | 74.5 | 42 | 05/14/2017 |
6 | aporo Gloster | 54,2 | 34 | 05/15/2017 |
7 | totoma Hainamana | 64 | 17 | 07/05/2017 |
8 | kūkamo pollinated | 110.6 | 28 | 05/16/2017 |
9 | kūkamo unsprayed | 132,9 | 28 | 05/01/2017 |
he ngä nui
Ko te tautohe tuarua ko te huru. Ki te hiahia tatou he tautohe ki whakapūtā te maha te wāhitau o te pūtau ranei, ka taea e koe te tuhi i te ara tika. Ki te hiahia tatou ki te hanga i te huru matatini ki te whakarite o ngā pūāhua, rapu mo te kuputuhi, he rā motuhake ranei, me te muia e te tautohe i roto i kōrero. Just raro reira e aparau i hoki pehea e taea te ngā mā te whakamahi i "amapehana" tohu i roto i ngā mahi e whakaratohia ana.
tikanga Simple mō te mahi
Rāwaho i roto i te wāhanga o mua, ka āwhina i te huinga raraunga mahi ki te "COUNTIF" i roto i Excel. Ko te tauira kōrero i roto i tēnei wāhanga e tino ohie, engari he ratou faufaa, a whakaaro ratou e tika ana, i mua i puta ki atu matatini.
I roto i te puka ripa whakaiti tatou te tātai, te hua o to ratou whakatinanatanga, me te tuhituhi i te kōrero whakamārama poto. hāngai ana te whakautu katoa e i runga i raraunga ripanga tomo i runga, ka rere i runga i te 16.05.2017 rā.
tauira | whakahoki | kōrero |
= COUNTIF (B2: B9; 74.5) | 2 | heheu te reira i te nui o hokohoko hokona i te utu 74.5 |
= COUNTIF (A2 A9, A2) | 1 | Ki te tenei tātai "makoha" ki te mutunga o te tepu, ka kite tatou, ki te whai tatou Tūemi tārite (ki te 1 - e te reira e kore) |
= COUNTIF (D2: D9; TODAY ()) | 2 | Tau o ngā pūtau ki nga taonga, ka kia wātea i teie mahana (te whakamahi i te rā pūnaha o te rorohiko) |
= COUNTIF (C2: C9, "") | 0 | e kiia te reira i te maha o ngā pūtau pātea i roto i te awhe. Whakatūpato! Ki te hoatu koe he wāhi i roto i te pūtau, e kore te reira e whakaaro rite te kau |
= COUNTIF (B2: B9; "<55") | 2 | Tau o ngā pūtau ki te uara o iti iho i te 55. Oia atoa, whakamana te whakarite kei te neke atu i te ">" kore rite ki "<>" |
= COUNTIF (B2: B9; "<55") + COUNTIF (B2: B9; "> 100") | 4 | Ko te tapeke o ngā pūtau i kitea i runga i te huinga o ngā āhuatanga e rua |
kārimākā
Kei te whānui nga kārimākā pera-ka karanga whakamahia ki te mahi "COUNTIF" i roto i Excel. Tauira kārimākā:
tohu | whakaahuatanga |
* | Kuputuhi (tetahi maha o pūāhua) |
? | Kuputuhi (maha o ngā pūāhua e ōrite ana ki te maha o tohu pātai). Mahi anake ki raraunga kuputuhi! Ki te kore te mea te pūtau, he pukapuka kotahi, e tonu 0 |
mahi tonu ki te papa i roto i Excel, ka tātari raraunga rongoa i roto i a ratou, ko te tata e taea waho te whakamahi o kārimākā.
Here mo te mahi ki te pūāhua kārimākā. te whakakotahi mahi
I ngā ki ētahi atu āhuatanga ki te hanga i ngā āhuatanga e hiahiatia puta tika ki te tikanga pūhui arorau ( "atu", "iti iho i te", "e kore e rite") me te tohu mahi "amapehana" e hiahiatia ana (k).
I roto i te puka ripa, whakaaro he tauira matatini ake o te whakamahi i te taputapu "COUNTIF."
tauira | whakahoki | kōrero |
= COUNTIF (A2: A9, "aporo") | 0 | Tau o ngā pūtau kei roto i te kupu "Apples" anake (take kiriuka), me katoa |
= COUNTIF (A2: A9: "aporo *") | 3 | Ko te maha o ngā pūtau e tīmata ana ki te kupu "aporo" me tetahi mutunga |
= COUNTIF (A2: A9; "* D *") | 3 | Ko te maha o ngā pūtau kei roto i te pukapuka "d" i roto i tetahi wahi o te kuputuhi. E mea pinepine whakamahia ki te kitea, ka whakakapi mo te atu "tuatahi" ki "i" me te "e" ki "e" |
= COUNTIF (A2: A9; "??????") | 1 | Products ki te ingoa o te roa o ngā pūāhua 6 anake |
= COUNTIF (D2: D9; "<" & (TODAY () - 10)) | 3 | Tau o ngā pūtau ki te rā o te hoko o neke atu i te kotahi tekau nga ra i mua |
= COUNTIF (C2: C9; ">" & AVERAGE (C2: C9)) | 3 | Tau o ngā pūtau ki te uara nui atu te utu hoko toharite |
whakaaro tenei te mutunga te "COUNTIF" i roto i Excel.
E tauturu i te mau hi'oraa i roto i roto i tenei tuhinga matau koutou nga mau parau tumu o te hanganga me ngā o ngā āhuatanga e kua whakamahia hei tautohe ki te mahi, a pai tono ratou i roto i te mahi.
Similar articles
Trending Now