Shandisa Excel yaAVERAGEIF kuregeredza Zero Maitiro paKutsvaga Average

IAVERAGEIF basa yakawedzerwa muExcel 2007 kuti zvive nyore kuwana huwandu hunokosha mune imwe nzvimbo ye data inosangana nechirevo chakatarwa.

Imwe nzira yakadaro yekushandira iyi ndeyokuti irege kukanganwa nheyo dzezero mumadhora anokanda mashizha kana arithmeti zvinoreva kana uchishandisa AVERAGE yenguva dzose basa .

Mukuwedzera kune dhesi iyo yakawedzerwa kune pepa rekushanda, zero zvigaro zvinogona kuva mugumisiro wekuenzanisa kwemazana - kunyanya kusina kukwana mapepa okushanda .

Ramba Zeros paKutsvaga Avhareji

Mufananidzo uyu uri pamusoro une fomu inoshandisa AVERAGEIF iyo inorega zero maitiro. Icho chirevo mumutsara unoita izvi " <> 0".

Iyo "<>" mhando ndiyo inenge isina kuenzanidza muExcel uye yakasikwa nekunyora mabhokoni ekukona - iri muzasi kwekona yekona ye keyboard - kudzokera kumashure;

Mienzaniso iri mumufananidzo yose inoshandisa imwechete yekugadzirisa-inongoratidzwa chete. Mhinduro dzakasiyana dzakawanikwa dzinokonzerwa nedzimwe nheyo dzakashandiswa mumutambo.

AVERAGEIF Function Syntax uye Augments

Mutsara webasa unoreva kurongeka kwebasa uye rinosanganisira zita rebasa , mabheji, uye nharo .

Mutsara weAVERAGEIF basa ndewekuti:

= AVERAGEIF (Range, Criteria, Average_range)

Mhedziso yeAVERAGEIF basa ndeyi:

Range - (inodikanwa) boka remasero basa racho richatsvaga kuti riwane mitsara yeCriteria argument iri pasi apa.

Zvinokonzerwa - (zvinodiwa) zvinosarudza kana data iri muchitokisi inofanira kuenzaniswa kana kwete

Avhareji -range - (zvichida) dhenda re data rakaenzana kana bhora rokutanga rinosangana nematanho akaiswa. Kana iyi nharo isingabvumirwi, nhamba iri muRange argument inotsanangurirwa pane-sezvinoratidzwa mumifananidzo iri mumufananidzo pamusoro apa.

IAVERAGEIF basa inoshora:

• Masero muAverage-range argument ine Boolean (TRUE kana FALSE) mararamiro - mutsara 5 pamusoro;
• Maseji ari muAvhareji_range ayo asina chinhu - mutsara 4 pamusoro;

Cherechedza:

• Kana kusina masero muRange akazadzisa zvinoratidzika, AVERAGEIF inodzorera # DIV / 0! kukanganisa kukosha - mutsara we 7 mumuenzaniso, apo masero ose muRange akaenzana ne zero.
• Kana nharo yeRange isisina zvachose kana inongova nemagwaro chete, AVERAGEIF inodzorera # DIV0! kukanganisa kukosha.- mitsara 6 ne8 pamusoro;

Ramba Zeros Muenzaniso

Zvisarudzo zvekupinda muAVERAGEIF basa uye nharo dzayo dzinosanganisira:

1. Kunyora basa rakakwana, rakadai se: = AVERAGEIF (A3: C3, "<> 0") mumusero webasa;
2. Kusarudza basa uye mazano aro uchishandisa AVERAGEIF basa dialog box.

Kunyange zvazvo zvichibvira kungopinda basa rakakwana nemunhu, vanhu vazhinji vanozviona zviri nyore kushandisa bhokisi rebhokisi sezvo rinotarisira kupinda mumashandisirwo emabasa - zvakadai seakakani uye kuparadzanisa kwemajaini kunodiwa pakati pemakakatanwa.

Mukuwedzera, kana basa racho uye nharo dzaro dzapinda mumunhu, nharo yeCriteria inofanira kunge yakapoteredzwa nemashoko ekuti: "<> 0" . Kana bhokisi rebhokisi rinoshandiswa kuisa basa, richawedzera mavheti okutora iwe.

Zvinyorwa pasi apa ndezvikwiriso zvinoshandiswa kupinda AVERAGEIF muchikamu cheD3 chemuenzaniso pamusoro apa uchishandisa bhokisi rebasa rebasa.

Kuvhura AVERAGEIF Dialog Box

1. Dzvanya pane cell D3 kuti iite iyo inoshandiswa sero - iyo nzvimbo iyo migumisiro yemabasa icharatidzwa;
2. Dzvanya paMafomu tab yebhoni ;
3. Sarudza Mamwe Mabasa> Statistical kubva kubhoni kuti uzarure basa rinoderedza pasi;
4. Dzvanya paAVERAGEIF mumutauro kuti ubudise bhokisi rebasa rebasa;
5. Mubhokisi rebhokisi, tora paRange line;
6. Simbisai masero A3 kusvika kuC3 mubasa rekushanda kuti uise iri bhanhire mubhokisi rebhokisi;
7. Pamutsetse weCriteria mubhokisi rebhokisi, tanga: <> 0 ;
8. Cherechedza: Average_range yakasara isina chinhu sezvo isu tiri kuwana huwandu hunokosha hwemasero akafanana akaiswa muRange argument;
9. Dzvanya OK kuti uvhare bhokisi rebhokisi uye dzokera kubasa rekushanda;
10. Mhinduro 5 inofanira kuonekwa muchitokisi D3;
11. Sezvo basa racho richikanganwa zero kukosha muchitokisi B3, muvhareji wemasero maviri akasara ndiwo 5: (4 + 6) / 2 = 10;
12. Kana iwe ukatora pane cell D8 basa rakakwana = AVERAGEIF (A3: C3, "<> 0") inowanikwa mubhairi yepamusoro pane pepa rekushanda.