Daatabeezete Asiishsha
Tini kifile daatunnita mitte haawiittimma mitte mareeko garinni kaa'litanno daatu qinaanbe assiishshubba shiqishshanno.
Daatu beeze fuuli LibreOfficegiddo karsamino daatu beeze ledo hawisara dandaanno. Ikkollana, LibreOfficegiddo nna LibreOfficeCalc giddo daatu beeze mereero xaadooshshu dino.
Lawishshu daata:
Aananno daati gama assiishshu xawishshu lawishshubbara kaa'lanno:
Hakka geeshshu A1:E10 Dirtuwa qaaqquullu ilamate barri jilira towaatanno. Aantanno mashalaqqe mitte mittente eora aamantino: caccafo A su'ma , B deerra, aantete diro, rosu mini fanfe meetiretenninna ayirra kiilo giraametenni leellishshanno.
A |
B |
C |
D |
E |
|
1 |
su'ma |
Kifile |
Diro |
Rosu mini fanfe |
Ayirra |
2 |
Nnay |
3 |
9 |
150 |
40 |
3 |
Betty |
4 |
10 |
1000 |
42 |
4 |
Charles |
3 |
10 |
300 |
51 |
5 |
Daniel |
5 |
11 |
1200 |
48 |
6 |
Eva |
2 |
8 |
650 |
33 |
7 |
Kifile |
2 |
7 |
300 |
42 |
8 |
Greta |
1 |
7 |
200 |
36 |
9 |
Harry |
3 |
9 |
1200 |
44 |
10 |
Irene |
2 |
8 |
1000 |
42 |
11 |
|||||
12 |
|||||
13 |
su'ma |
Kifile |
Diro |
Rosu mini fanfe |
Ayirra |
14 |
>600 |
||||
15 |
|||||
16 |
DCOUNT |
5 |
Bisicco B16giddo afirimali =DCOUNT(A1:E10;0;A13:E14)
Daatubeeze Assiishshi Eishshuwa:
Ananno uduunni baala daatubeeze assiishshubbara eishshu tirubbaati:
Daatubeeze bisiccote hakka geeshsha ikkite daatubeezenni tirantinote.
DatabaseField specifies the column where the function operates on after the search criteria of the first parameter is applied and the data rows are selected. It is not related to the search criteria itself. For the DatabaseField parameter you can enter a reference to a header cell or a number to specify the column within the Database area, starting with 1. To reference a column by means of the literal column header name, place quotation marks around the header name.
SearchCriteria Bisiccote hakka geeshsha ikkite hasiwonshiworcho amaddinote. Batinye wonshiworcho mitte hawiittimma giddo borreessittoro insano AND amadantanno. Batinye wonshiworcho babbaxxitino hawiittimmooti giddo borreessittoro insano OR amadantanno. Hasate wonshiworcho hakka geeshshi giddo mullicho bisiccuwa agurama noose.
LibreOffice - DooroUduunnu - doorshuwa - LibreOffice Calc - shallaga LibreOffice Calc hiitoonni loosannore tirate mittu dani eubba dooranno.
See also the Wiki page about Conditional Counting and Summation.
DAVERAGE
DAVERAGE baala haawiittimmooti giddo (daatubeeze maareekkuwara) baxxino hasote wonshiworcho fixoonsitanno baala bisiccuwa (hornyuwa)hornyuwate mereerima qolanno.
Ganallo
DAVERAGE(Daatubeeze; DatabaseField; SearchCriteria)
Lawishsha
Aliidi lawishshi giddo (ballo; aleegisse gonggo'mishi)dirinisa mitto ikkino ooso mereerima ayirra afate B16 giddo aananno afirimala ei:
=DAVERAGE(A1:E10;"Ayirra";A13:E14)
Hawiittimma 14 giddo, kifilete deerri woroonni, 7, 8, 9, nna woleno , mitto wolu gedensaanni ei. Dirinisa mitto ikkino baala ooso mereerima ayirra shiqqanno.
DCOUNT
DCOUNT daatu beeze giddo baxxino hasate wonshiworcho fixoonsanno nna kiirote hornyuwa amadino hawiittimmootu kiiro (maareekkuwa) kiiranno.
Ganallo
DCOUNT(Daatubeeze; DatabaseField; SearchCriteria)
If the DatabaseField argument is omitted, DCOUNT returns the count of all records that satisfy Criteria. For the DatabaseField parameter you can enter a reference to a header cell or a number to specify the column within the Database area, starting with 1. To reference a column by means of the literal column header name, place quotation marks around the header name.
Lawishsha
Aliidi lawishshi giddo (ballo; aleegisse gonggo'mishi), rosu minira 600 meetire aleennihadhannori me"e oosootiro afa hasi'neemmo. Gumu bisiccobisicco B16 giddo kuusamino. Wirrisa bisicco B16 giddo qineessi. =DCOUNT(A1:E10;0;A13:E14) afirimala B16 giddo ei. Assiishshu kaa'laanchi hakka geeshshuwa giddo worattora kaa'lannohe.
Daatubeeze keenama noosi daati hakka geeshshaati, umaalluwantenni ledo: konni garinni A1:E10. daatubeezeBara hasate wonshiworchora caccafo badanno: konni garinni, woma daatu beeze. hasate wonshiworcho hasate eishshuwa eate dandaatto dargi hakka geeshshaati: konni garinni, A13:E14.
Layinki kifile giddo dirinsa 7 aleenni higinori me"e ooso nooro rosate, bisiccote D14 giddo >600 ea nna 2 Bisicco B14 giddo kifilete woroonni ea, nna >7 bisicco C14 giddo qiniiteenni. Gumu 2. Layinki kifilera lamu ooso diri 7 aleenniiti. Mittu dani haawiittimma giddo lamunku wonshiworcho gede, insano AND amadisiisantino.
DCOUNTA
DCOUNTA daatu beeze giddo baxxino hasate wonshiworcho fixoonsanno nna kiirote hornyuwa amadino hawiittimmootu kiiro (maareekkuwa) kiiranno.
Ganallo
DCOUNTA(Daatubeeze; DatabaseField; SearchCriteria)
If the DatabaseField argument is omitted, DCOUNTA returns the count of all records that satisfy Criteria. For the DatabaseField parameter you can enter a reference to a header cell or a number to specify the column within the Database area, starting with 1. To reference a column by means of the literal column header name, place quotation marks around the header name.
Lawishsha
Aliidi lawishshi giddo (ballo; aleegisse gonggo'mishi), su'minsa E fidalenni woy cinaanchotenni hanafannoooso kiiro hasa dandaatto. Afirimala B16 giddo nabbawate =DCOUNTA(A1:E10;"Su'ma";A13:E14)muccisi. Akala hasi wonshiworcho huna nna >=E bare A14 giddo su'ma ei. Gumu 5. Hawiittimma 8 giddo ggretahobaala kiirote hornyuwaxaa hunittoro, gumu 4 soorramanno. Haawiittimma 8 kiirote giddo lowo geeshsha dieino korkaatuno hornyuwa diamaddino. Su'mu Greta borrote, dihornyote. Qaagi DatabaseField eishshi hornyuwa amada dandiitanno caccafowa widira leellishanno.
DGET
DGET daatubeeze giddo baxxitino haso wonshiworcho fixoonsanno maqisantino amadubba qolanno. So'rotenni, Assiishshu woy #VALUE! hawiittimma anfannikkihura, woy Err502 mitte bisicco aleenni anfannihura qolanno.
Ganallo
DGET(Daatubeeze; DatabaseField; SearchCriteria)
Lawishsha
Aliidi lawishshi giddo (ballo; aleegisse gonggo'mishi), su'minsa bisicco A14 giddo eino beettu me"e kifile giddo nooro gumula hasi'noommo. Bisicco B16 giddo eino afirimali umi lawishshinni sunuutunni baxxanno korkaatuno mitte caccafo(mitte daatubeeze bare) calla Daatubeezebareeino. Aananno afirimala ei:
=DGET(A1:E10;"Kifile";A13:E14)
KonneFrank A14 giddo su'ma ei, nna guma 2 la"atto. Frank lame kifileeti. Enter "Kifilete" darga "Diro" ei Frank's diro afiratto.
Woy 11 bisicco C14 giddo calla ei, nna tenne hawiittimma giddo wole eubba huni. Afirimala B16 giddo aananno garinni muccisi:
=DGET(A1:E10;"Su'ma";A13:E14)
Kifilete darga, su'mu shiqino. Dawaro mitte higge shiqquro: Daniel callu 11 diri beettooti.
DMAX
DMAX daatubeeze (baala maareekuwa) giddo baxxitino hasote ikkitubbara fiixoontinobisiccote (barete) jawiidi amado qolanno.
Ganallo
DMAX(Daatubeeze; DatabaseField; SearchCriteria)
Lawishsha
Aliidi lawishshi giddo (ballo; aleegisse gonggo'mishi) mageeshsha ayiranno beetti, kifilete giddo nooro afate B16 giddo aananno afirimala ei:
=DMAX(A1:E10;"Ayirra";A13:E14)
Under Grade, enter 1, 2, 3, and so on, one after the other. After entering a grade number, the weight of the heaviest child in that grade appears.
DMIN
DMIN daatubeeze giddo baxxitino hasote wonshiworcho fiixoontino bisiccote (barete) shimiidi amado qolanno.
Ganallo
DMIN(Daatubeeze; DatabaseField; SearchCriteria)
Lawishsha
Aliidi lawishshi giddo (ballo; aleegisse gonggo'mishi)mitte mittente kifilera oosote rosu mininni harancho fanfe afate B16 giddo aananno afirimala ei:
=DMIN(A1:E10;"Rosu mini geeshsha noo fanfe";A13:E14)
Hawiittimma 14 giddo, kifilete deerri woroonni, enter 1, 2, 3, nna woleno, mitto wolu gedensaanni ei. Mitte mittente kifilera rosuminiti harancho fanfe shiqqanno.
DPRODUCT
DPRODUCT bisiccote amadubba hasote wonshiworcho fixoonsitanno darga baala bisiccoota daatu hakka geeshshiha shallaganno.
Ganallo
DPRODUCT(Daatubeeze; DatabaseField; SearchCriteria)
Lawishsha
Aliidi lawishshira ilamate jili ledo (ballo aleegisse gongo'mishshi), konni assiishshira tiro afidhino pirogiraame dino.
DSTDEV
DSTDEV akeeku kaiminni, aamantino ikkitubba fiixoonsitannota daatu giddo caccafo kiiro horoonsiratenni dagatnniha margeessu malaate shallaganno. Maareekkuwa daatu akeeki gede dogisiisantino. Togo yaa lawishshi giddo ooso baala ooso gutu kifile riqibbanno . Qaagi riqiwote gumi mittu kuminniajanno akeekiwiinniafama didandaanno.
Ganallo
DSTDEV(Daatubeeze; DatabaseField; SearchCriteria)
Lawishsha
Lawishshi giddo (ballo; aleegisse gonggo'mishi)dirinisa mitto ikkino baala ooso margeessu malaatta ayirra afate B16 giddo aananno afirimala ei:
=DSTDEV(A1:E10;"Ayirra";A13:E14)
Hawiittimma 14 giddo, kifilete deerri woroonni, 7, 8, 9, nna woleno , mitto wolu gedensaanni ei. Konni diri baala ooso ayirra margeessu malaati gumi leellanno.
DSTDEVP
DSTDEVP bisiccote amadubba hasote wonshiworcho fixoonsanno baala bisiccoota daatu hakka geeshshihi margeessu malaate shallaganno. Lawishshu maareekkuwa wo'ma daga gede dogisiisantanno.
Ganallo
DSTDEVP(Daatubeeze; DatabaseField; SearchCriteria)
Lawishsha
Joe's ilamate barri jilira (ballo; aleegisse gonggo'mishi)dirinisa mitto ikkino baala ooso margeessu malaatta ayirra afate B16 giddo aananno afirimala ei:
=DSTDEVP(A1:E10;"Ayirra";A13:E14)
Hawiittimma 14 giddo, kifilete deerri woroonni, 7, 8, 9, nna woleno , mitto wolu gedensaanni ei. Baala mittu dani diri ooso ayirra margeessu malaati gumi ayira buuxantanno.
DSUM
DSUM baala haawiittimmooti giddo (maareekkuwara) baxxino hasote wonshiworcho fixoonsitanno daatubeeze bare giddo baala bisiccuwa xaphooma qolanno.
Ganallo
DSUM(Daatubeeze; DatabaseField; SearchCriteria)
Lawishsha
Joe's ilamate barri jilira (ballo; aleegisse gonggo'mishi) dirinisa mitto ikkino baala ooso margeessu malaatta ayirra afate B16 giddo aananno afirimala ei:
=DSUM(A1:E10;"Rosu mini geeshsha noo fanfe";A13:E14)
Haawiittimma 14 giddo 2 kifilete deerri woroonni ei. Lame kifile baala ooso rosu mini fanfe ledo (1950) leellishanno.
DVAR
DVAR baxxino hasote wonshiworcho fixoonsitannobaala maareekkuwa giddo baala bisiccuwa daatu beeze bareha badooshshe qolanno. Maareekkuwa daatu akeeki gede dogisiisantino. Riqiwote gumi mittu kuminni ajanno akeeku dagawiinni afama didandaanno.
Ganallo
DVAR(Daatubeeze; DatabaseField; SearchCriteria)
Lawishsha
Aliidi lawishshi giddo (ballo; aleegisse gonggo'mishi)dirinisa mitto ikkino ooso badooshshu ayirra afate B16 giddo aananno afirimala ei:
=DVAR(A1:E10;"Ayirra";A13:E14)
Hawiittimma 14 giddo, kifilete deerri woroonni, 7, 8, 9, nna woleno , mitto wolu gedensaanni ei. Konni diri baala ooso ayirra badooshshe guma gede la"atto.
DVARP
DVARP bisiccote hornyuwa hasote wonshiworcho fixoonsitanno darga baala bisiccoota badooshshe shallaganno. Lawishshu maareekkuwa eote daga gede dogisiisantanno.
Ganallo
DVARP(Daatubeeze; DatabaseField; SearchCriteria)
Lawishsha
Joe's ilamate barri jilira (ballo; aleegisse gonggo'mishi)dirinisa mitto ikkino baala ooso badooshshu ayirra afate B16 giddo aananno afirimala ei:
=DVARP(A1:E10;"Ayirra";A13:E14)
Hawiittimma 14 giddo, kifilete deerri woroonni, 7, 8, 9, nna woleno , mitto wolu gedensaanni ei. Dirinisa mitto ikkino baala ooso Joe'silamate barri jila beeqqitinore shiqishanno.