Zosavuta COUNT - INDIRECT Makhalidwe

Mawerengero Awerengero, Nthawi, kapena Malemba mu Excel

Kugwiritsa ntchito INDIRECT ntchito mu Excel mafomu kumapangitsa kukhala kosavuta kusinthanitsa mafotokozedwe a selo ogwiritsidwa ntchito mu njirayi popanda kusintha ndondomeko yokha.

CHIKHALIDWE chingagwiritsidwe ntchito ndi ntchito zingapo zomwe zimalandila selolo ngati sewero monga ntchito SUM ndi COUNT.

Pachifukwa chotsatira, kugwiritsa ntchito INDIRECT monga kukangana kwa COUNT kumapanga mafotokozedwe amphamvu a ma selo omwe angathe kuwonetsedwa ndi ntchitoyi.

ZOKHUDZA ZOCHITA izi ndikutembenuza deta pamtundu - nthawi zina zimatchulidwa ngati chingwe cholembera - mu selo lotanthauzira.

Chitsanzo: Kugwiritsa Ntchito Mphamvu ndi COUNT - INDIRECT Formula

Chitsanzo ichi chazikidwa pazithunzi zomwe zawonetsedwa pa chithunzi pamwambapa.

Chigawo cha COUNT - CHIWIRI chomwe chinapangidwa mu phunziro ndi:

= COUNT (INDIRECT (E1 & ":" & E2))

Mu chidule ichi, mtsutso wa INDIRECT ntchito uli ndi:

• zizindikiro za maselo E1 ndi E2 - zomwe zili ndi deta D1 ndi D5
• choyendetsa - chida (:) chozunguliridwa ndi ndondomeko zotsindikizira kawiri ( "" ), zomwe zimatembenuza coloni kukhala chingwe cholembera
• Ambiri ampersands ( & ) omwe amagwiritsidwa ntchito kusinthanitsa kapena kulumikiza pamodzi coloni ndi mafotokozedwe a selo E1 ndi E2

Chotsatira ndi chakuti INDIRECT amasintha chingwe chojambulidwa D1: D5 mu selo loyang'anapo ndikuchidutsa pamodzi ndi COUNT ntchito.

Kusintha Kwambiri Mchitidwe & # 39; s Range

Kumbukirani, cholinga chake ndi kupanga chikhazikitso ndi njira yopambana - yomwe ingasinthidwe popanda kusintha ndondomeko yokha.

Pogwiritsa ntchito deta yomwe ili m'maselo E1 ndi E2, kuchokera ku D1 ndi D5 mpaka D3 ndi D6, mwachitsanzo, kusiyana komwe kumagwira ntchito kungasinthe mosavuta kuchokera pa D1: D5 mpaka D3: D6.

Izi zimathetsa kufunika kolemba njirayi mu selo G1.

Kulowa Datorial Data

1. Lowetsani deta zotsatirazi mu maselo D1 mpaka E2
2. Cell Data D1 - 1 D2 - awiri D3 - 3 D5 - 5 D6 - asanu E1 - D1 E2 - D5 F1 - Wowerengera:

Kulowa mu COUNT - INDIRECT Formula

1. Dinani pa selo G1 - izi ndi zomwe zotsatira za chitsanzo ichi zidzawonetsedwa
2. Lowani ndondomeko: = COUNT (INDIRECT (E1 & ":" & E2))
3. Lembani fungulo lolowamo lolowamo mu khibhodi kuti mukwaniritse ntchitoyo
4. Selo G1 iyenera kukhala ndi yankho la 3

Dziwani kuti ntchito COUNT imangokhala maselo omwe ali ndi manambala, kotero kuti ngakhale ma selo asanu pa D1: D5 ali ndi deta, maselo atatu okha ali ndi manambala.

Maselo omwe alibe kanthu kapena ali ndi deta ma data sakusamalidwa ndi ntchitoyo.

Kusintha Machitidwe & # 39; s Range

1. Dinani pa selo E1
2. Lowetsani selo la D3
3. Dinani pakiyi ya Kulowa pa makiyi kuti musunthire ku selo E2
4. Mu selo iyi mulowetse selolo D6
5. Dinani ku key lolowamo pa khibhodi
6. Yankho lake mu selo G1 liyenera kusintha mpaka 2 popeza maselo awiri okhawo atsopano D3: D6 ali ndi manambala

COUNTA, COUNTBLANK ndi INDIRECT

Ntchito zina ziwiri za Excel count ndi COUNTA - zomwe zimawerengera maselo omwe ali ndi mtundu uliwonse wa deta - kusasamala maselo opanda kanthu kapena opanda pake, ndi COUNTBLANK , omwe amawerengera chabe maselo opanda kanthu kapena opanda kanthu.

Popeza ntchito zonsezi zili ndi mawu ofanana ndi machitidwe COUNT, iwo akhoza kulowetsedwa mu chitsanzo chapamwamba ndi INDIRECT kuti apange mafomu awa:

= COUNTA (INDIRECT (E1 & ":" & E2))

= COUNTBLANK (INDIRECT (E1 & ":" & E2))

Kwa ma D1: D5, COUNTA angayankhe yankho la 4 - popeza maselo anayi ali ndi deta, ndipo OUNTBLANK ndi yankho la 1 - popeza pali selo limodzi lokha losawerengeka.