Ƙididdigar Siffofin Bayanai tare da Ayyukan Harkokin Hutun na Excel

Ayyukan SUMPRODUCT a Excel shine aikin da ya dace wanda zai ba da sakamako daban-daban dangane da muhawarar da aka shigar.

Abin da aikin SUMPRODUCT yake yi shi ne ninka abubuwa na ɗaya ko fiye da kayan aiki sannan kuma ƙara ko ƙayyade samfurori tare.

Amma ta daidaita daidaitattun jayayya, SUMPRODUCT zai ƙidaya yawan adadin sel a cikin wani jeri wanda aka ba da bayanai wanda ya dace da ka'idodi.

01 na 04

SUMPRODUCT vs. COUNTIF da COUNTIFS

Tun da Excel 2007, wannan shirin yana da COUNTIF da kuma ayyukan COUNTIFS wanda zai ba ka damar ƙidaya tantanin da ke biye da ɗaya ko fiye da ka'idoji.

A wasu lokuta, duk da haka, SUMPRODUCT ya fi sauƙin aiki tare da lokacin da aka samo wasu sharuɗɗan sharuɗɗa da suka shafi iri ɗaya kamar yadda aka nuna a misali wanda ke cikin hoton da ke sama.

02 na 04

SUMPRODUCT Ayyukan aiki da jayayya zuwa ƙwayoyin ƙira

Haɗin aikin aiki yana nufin layout na aikin kuma ya haɗa da sunan aiki, shafuka, rabuɗɗun takaddama, da muhawara .

Don samun aikin don ƙidaya yawan ƙwayoyin maimakon yin abin da ya dace, dole ne a yi amfani da daidaitattun daidaitattun ba tare da SUMPRODUCT:

= SUMPRODUCT ([condition1] * [yanayin2])

Bayani na yadda wannan haɗin aikin yake ƙayyade a kasa da misali mai zuwa.

Misali: Ƙirƙirar ƙwayoyin da ke saduwa da Maɓallai Maɗaukaki

Kamar yadda aka nuna a misali a cikin hoton da ke sama, An yi amfani da SUMUCATION don samo yawan adadin kwayoyin halitta a cikin jerin bayanai na A2 zuwa B6 wanda ya ƙunshi bayanan da ke tsakanin dabi'un 25 da 75.

03 na 04

Shigar da aikin SUMPRODUCT

A al'ada, hanya mafi kyau don shigar da ayyuka cikin Excel shi ne yin amfani da akwatin maganganu , wanda zai sa ya sauƙi shigar da muhawara daya lokaci ba tare da shigar da ƙuƙwalwa ba ko kalmomi da suke aiki a matsayin rabuwa tsakanin gardama.

Duk da haka, saboda wannan misali yana amfani da nauyin da ba daidai ba ne na aikin SUMPRODUCT, ba za'a iya amfani da akwatin maganganun ba. Maimakon haka, dole ne a danna aikin a cikin sashin layi.

A cikin hoton da ke sama, an yi amfani da matakai na gaba don shigar da SUMPRODUCT a cikin sel B7:

1. Danna kanfikan B7 a cikin takardun aiki - wurin da za a nuna sakamakon aikin
2. Rubuta ma'anar wannan a cikin kwayar halitta E6 na takardun aiki:

   = SUMPRODUCT (($ A $ 2: $ B $ 6> 25) * ($ A $ 2: $ B $ 6 <75))

3. Amsar 5 ya kamata ya bayyana a cikin tantanin halitta B7 saboda akwai nau'o'i biyar kawai a cikin kewayon - 40, 45, 50, 55, da 60 - wadanda ke tsakanin 25 zuwa 75
4. A yayin da ka danna kan tantanin B7 da aka kammala daidai = SUMPRODUCT (($ A $ 2: $ B $ 6> 25) * ($ A $ 2: $ B $ 6 <75)) ya bayyana a cikin maɓallin tsari a sama da takardun aiki

04 04

Kaddamar da Ƙa'idar SUMPRODUCT

Lokacin da aka saita yanayi don muhawarar, SUMPRODUCT yana kimanta kowane nau'in tsararru akan yanayin kuma ya dawo da darajar Boolean (TRUE ko FALSE).

Don dalilai na ƙididdiga, Excel ya ba da darajar 1 don waɗannan abubuwan tsararru waɗanda suke TRUE da darajar 0 don abubuwan tsararru waɗanda suke FALSE.

Abubuwan da suka dace da nau'i a kowane tashoshi suna haɗuwa tare:

• tare da 1 x 1 dawo da darajar 1
• tare da 1 x 0 dawo da darajar 0

Wadannan kuma nau'ikan suna ƙayyade ta wurin aikin don ba mu ƙididdiga yawan lambobin da suka dace da duka sharuɗɗa.

Ko kuwa, yi la'akari da shi ta wannan hanya ...

Wata hanyar da za ta yi tunani game da abin da ABUBUWAN ke yi shi ne yin la'akari da alamar ƙaddamarwa a matsayin ƙa'idar AND .

Da wannan a zuciyarsa, kawai idan an hadu da waɗannan yanayi - lambobin da suka fi 25 DA ƙasa da 75 - cewa an mayar da Ƙimar TRUE (wanda yake daidai da ɗaya tuna).

Ayyukan sannan ya tara dukkanin dabi'un gaskiya don isa a sakamakon 5.