Nhamba Dhamba, Mazuva, kana Mhemberero muExcel
Kushandisa INDIRECT basa muExpcel mazano kunoita kuti zvive nyore kuchinja mararamiro esero rinoshandiswa mumutsetse kunze kwekushandura iyo fomu pachayo.
INDIRECT inogona kushandiswa nehuwandu hwemabasa anogamuchira seferensi rekero senharo dzakadai seSUM uye COUNT mabasa.
Muchiitiko chekupedzisira, kushandisa INDIRECT sekukakavadzana kwe COUNT kunobatanidza huwandu hwakawanda hwemasero emaferensi anogona kuenzaniswa nebasa racho.
INDIRECT inoita izvi kuburikidza nekushandura deta data-dzimwe nguva kunonzi seyoti chinyorwa -muchikamu chekutarisa.
Muenzaniso: Kushandisa Dynamic Range ne COUNT - INDIRECT Formula
Uyu muenzaniso unobva pane data inoratidzwa mumufananidzo pamusoro apa.
I-COUNT - INDIRECT yakasikwa yakagadzirwa mumudzidzi ndeyokuti:
= COUNT (INDIRECT (E1 & ":" & E2))
Muchirevo ichi, gakava re INDIRECT rinosanganisira:
- sero rinoshandiswa E1 neE2 - rine zvinyorwa D1 uye D5
- mutambi wepamusoro - colon (:) yakakomberedzwa nemavhoti maviri ezvinyorwa ( "" ), iyo inoshandura chikoni kuva chinyorwa chine
- Mamwe ampersands ( & ) anoshandiswa kubatanidza kana kubatanidza pamwe nekoloni ine zvinyorwa zvitsanangudzo E1 neE2
Chigumisiro ndechokuti INDIRECT inoshandura mutsetse chinyorwa D1: D5 muchikamu chetere uye ichichipfuura pamwe ne COUNT basa rinofanira kuiswa.
Kushandura Kwazvo Somu & R 39; s Range
Yeuka, chinangwa ndechokugadzira fomu nemhando yakasimba- imwe inogona kuchinjwa pasina kugadzirisa fomu yacho pachayo.
Nokushandura dhidhiyo data iri mumasero E1 neE2, kubva D1 uye D5 kusvika D3 uye D6 somuenzaniso, uwandu hwakazara nebasa hunogona kushandurwa zviri nyore kubva D1: D5 kusvika D3: D6.
Izvi zvinobvisa chido chekugadzirisa fomu muchitokisi G1.
Kupinda Tutorial Data
- Isa data inotevera inhengo D1 kusvika E2
- Cell Data D1 - 1 D2 - maviri D3 - 3 D5 - 5 D6 - matanhatu E1 - D1 E2 - D5 F1 - Verengai:
Kupinda COUNT - INDIRECT Formula
- Dzvanya pane cell G1 - iyi ndiyo iyo migumisiro yemuenzaniso uyu icharatidzwa
- Pinda mufananidzo: = COUNT (INDIRECT (E1 & ":" & E2))
- Dhinda pikicha inopinda mubhokisi kuti upedze basa
- Sero G1 inofanira kuva nemhinduro ye3
Cherechedza maitiro COUNT chete anoverenga masero ane nhamba, naizvozvo kunyange zvazvo mana emakamuri mashanu ari muD1: D5 ane data, masero matatu chete ane nhamba.
Maseji ayo asina chinhu kana kuti ane deta deta haatauri nemabasa.
Kugadzirisa Mhando & s 39 Range
- Dzvanya pane cell E1
- Pinda sero rekushandisa D3
- Dhinda pikicha inopinda mubhobhoyo kuti uende kune cell E2
- Mune kamuri iyi shandisa sero rinoreva D6
- Dhinda pikicha inopinda mubhokisi
- Mhinduro yacho muchitokisi G1 inofanira kuchinja kusvika 2 sezvo masero maviri chete ari mazera matsva D3: D6 ane nhamba
COUNTA, COUNTBLANK uye INDIRECT
Mamwe mairi maviri Excel count mabasa ndeye COUNTA - iyo inofanidza masero ane zverudzi rwemhando yese - kusachengeta masero asina chinhu kana asina chinhu, uye COUNTBLANK , iyo inongoratidzira masero mashoma kana asina chinhu mukati.
Sezvo zvose zviri zviviri izvi zvine maitiro akafanana neakaitwa COUNT, zvinogona kuiswa panzvimbo yepamusoro ne INDIRECT yekuumba mazano awa:
= COUNTA (INDIRECT (E1 & ":" & E2))
= COUNTBLANK (INDIRECT (E1 & ":" & E2))
Nokuda kwenharaunda D1: D5, COUNTA inodzorera mhinduro ye4 - sezvo mana emasero mashanu ane data, uye OUNTBLANK uye mhinduro ye-1 - sezvo pane imwe chete isina chengesi iri mukati.