Daatabeezete Asiishsha

Tini kifile daatunnita mitte haawiittimma mitte mareeko garinni kaa'litanno daatu qinaanbe assiishshubba shiqishshanno.

note

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:

Database is the cell range defining the database. The first row of the range contains the field names, and following rows are records with corresponding field values.

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 (from the first row of Database range), place quotation marks around the header name.

SearchCriteria is the cell range containing search criteria. Like Database, its first row is also field names, and following rows are conditions for related fields. If you write several criteria in one row they are connected by AND. If you write the criteria in different rows they are connected by OR. Empty cells in the search criteria range will be ignored.

Choose - LibreOffice Calc - Calculate to define how LibreOffice Calc acts when searching for identical entries.

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.

The search supports wildcards or regular expressions. With regular expressions enabled, you can enter "all.*", for example to find the first location of "all" followed by any characters. If you want to search for a text that is also a regular expression, you must either precede every character with a "\" character, or enclose the text into \Q...\E. You can switch the automatic evaluation of wildcards or regular expression on and off in - LibreOffice Calc - Calculate.

warning

When using functions where one or more arguments are search criteria strings that represents a regular expression, the first attempt is to convert the string criteria to numbers. For example, ".0" will convert to 0.0 and so on. If successful, the match will not be a regular expression match but a numeric match. However, when switching to a locale where the decimal separator is not the dot makes the regular expression conversion work. To force the evaluation of the regular expression instead of a numeric expression, use some expression that can not be misread as numeric, such as ".[0]" or ".\0" or "(?i).0".


Syntax

DAVERAGE(Daatubeeze; DatabaseField; SearchCriteria)

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 (from the first row of Database range), place quotation marks around the header name.

Example

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.

The search supports wildcards or regular expressions. With regular expressions enabled, you can enter "all.*", for example to find the first location of "all" followed by any characters. If you want to search for a text that is also a regular expression, you must either precede every character with a "\" character, or enclose the text into \Q...\E. You can switch the automatic evaluation of wildcards or regular expression on and off in - LibreOffice Calc - Calculate.

warning

When using functions where one or more arguments are search criteria strings that represents a regular expression, the first attempt is to convert the string criteria to numbers. For example, ".0" will convert to 0.0 and so on. If successful, the match will not be a regular expression match but a numeric match. However, when switching to a locale where the decimal separator is not the dot makes the regular expression conversion work. To force the evaluation of the regular expression instead of a numeric expression, use some expression that can not be misread as numeric, such as ".[0]" or ".\0" or "(?i).0".


Syntax

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 (from the first row of Database range), place quotation marks around the header name.

If you choose to omit the DatabaseField argument, your formula should be of the form =DCOUNT(Database; ; SearchCriteria).

Example

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.

The search supports wildcards or regular expressions. With regular expressions enabled, you can enter "all.*", for example to find the first location of "all" followed by any characters. If you want to search for a text that is also a regular expression, you must either precede every character with a "\" character, or enclose the text into \Q...\E. You can switch the automatic evaluation of wildcards or regular expression on and off in - LibreOffice Calc - Calculate.

warning

When using functions where one or more arguments are search criteria strings that represents a regular expression, the first attempt is to convert the string criteria to numbers. For example, ".0" will convert to 0.0 and so on. If successful, the match will not be a regular expression match but a numeric match. However, when switching to a locale where the decimal separator is not the dot makes the regular expression conversion work. To force the evaluation of the regular expression instead of a numeric expression, use some expression that can not be misread as numeric, such as ".[0]" or ".\0" or "(?i).0".


Syntax

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 (from the first row of Database range), place quotation marks around the header name.

If you choose to omit the DatabaseField argument, your formula should be of the form =DCOUNTA(Database; ; SearchCriteria).

Example

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.

The search supports wildcards or regular expressions. With regular expressions enabled, you can enter "all.*", for example to find the first location of "all" followed by any characters. If you want to search for a text that is also a regular expression, you must either precede every character with a "\" character, or enclose the text into \Q...\E. You can switch the automatic evaluation of wildcards or regular expression on and off in - LibreOffice Calc - Calculate.

warning

When using functions where one or more arguments are search criteria strings that represents a regular expression, the first attempt is to convert the string criteria to numbers. For example, ".0" will convert to 0.0 and so on. If successful, the match will not be a regular expression match but a numeric match. However, when switching to a locale where the decimal separator is not the dot makes the regular expression conversion work. To force the evaluation of the regular expression instead of a numeric expression, use some expression that can not be misread as numeric, such as ".[0]" or ".\0" or "(?i).0".


Syntax

DGET(Daatubeeze; DatabaseField; SearchCriteria)

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 (from the first row of Database range), place quotation marks around the header name.

Example

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.

The search supports wildcards or regular expressions. With regular expressions enabled, you can enter "all.*", for example to find the first location of "all" followed by any characters. If you want to search for a text that is also a regular expression, you must either precede every character with a "\" character, or enclose the text into \Q...\E. You can switch the automatic evaluation of wildcards or regular expression on and off in - LibreOffice Calc - Calculate.

warning

When using functions where one or more arguments are search criteria strings that represents a regular expression, the first attempt is to convert the string criteria to numbers. For example, ".0" will convert to 0.0 and so on. If successful, the match will not be a regular expression match but a numeric match. However, when switching to a locale where the decimal separator is not the dot makes the regular expression conversion work. To force the evaluation of the regular expression instead of a numeric expression, use some expression that can not be misread as numeric, such as ".[0]" or ".\0" or "(?i).0".


Syntax

DMAX(Daatubeeze; DatabaseField; SearchCriteria)

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 (from the first row of Database range), place quotation marks around the header name.

Example

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.

The search supports wildcards or regular expressions. With regular expressions enabled, you can enter "all.*", for example to find the first location of "all" followed by any characters. If you want to search for a text that is also a regular expression, you must either precede every character with a "\" character, or enclose the text into \Q...\E. You can switch the automatic evaluation of wildcards or regular expression on and off in - LibreOffice Calc - Calculate.

warning

When using functions where one or more arguments are search criteria strings that represents a regular expression, the first attempt is to convert the string criteria to numbers. For example, ".0" will convert to 0.0 and so on. If successful, the match will not be a regular expression match but a numeric match. However, when switching to a locale where the decimal separator is not the dot makes the regular expression conversion work. To force the evaluation of the regular expression instead of a numeric expression, use some expression that can not be misread as numeric, such as ".[0]" or ".\0" or "(?i).0".


Syntax

DMIN(Daatubeeze; DatabaseField; SearchCriteria)

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 (from the first row of Database range), place quotation marks around the header name.

Example

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.

The search supports wildcards or regular expressions. With regular expressions enabled, you can enter "all.*", for example to find the first location of "all" followed by any characters. If you want to search for a text that is also a regular expression, you must either precede every character with a "\" character, or enclose the text into \Q...\E. You can switch the automatic evaluation of wildcards or regular expression on and off in - LibreOffice Calc - Calculate.

warning

When using functions where one or more arguments are search criteria strings that represents a regular expression, the first attempt is to convert the string criteria to numbers. For example, ".0" will convert to 0.0 and so on. If successful, the match will not be a regular expression match but a numeric match. However, when switching to a locale where the decimal separator is not the dot makes the regular expression conversion work. To force the evaluation of the regular expression instead of a numeric expression, use some expression that can not be misread as numeric, such as ".[0]" or ".\0" or "(?i).0".


Syntax

DPRODUCT(Daatubeeze; DatabaseField; SearchCriteria)

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 (from the first row of Database range), place quotation marks around the header name.

Example

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.

The search supports wildcards or regular expressions. With regular expressions enabled, you can enter "all.*", for example to find the first location of "all" followed by any characters. If you want to search for a text that is also a regular expression, you must either precede every character with a "\" character, or enclose the text into \Q...\E. You can switch the automatic evaluation of wildcards or regular expression on and off in - LibreOffice Calc - Calculate.

warning

When using functions where one or more arguments are search criteria strings that represents a regular expression, the first attempt is to convert the string criteria to numbers. For example, ".0" will convert to 0.0 and so on. If successful, the match will not be a regular expression match but a numeric match. However, when switching to a locale where the decimal separator is not the dot makes the regular expression conversion work. To force the evaluation of the regular expression instead of a numeric expression, use some expression that can not be misread as numeric, such as ".[0]" or ".\0" or "(?i).0".


Syntax

DSTDEV(Daatubeeze; DatabaseField; SearchCriteria)

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 (from the first row of Database range), place quotation marks around the header name.

Example

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.

The search supports wildcards or regular expressions. With regular expressions enabled, you can enter "all.*", for example to find the first location of "all" followed by any characters. If you want to search for a text that is also a regular expression, you must either precede every character with a "\" character, or enclose the text into \Q...\E. You can switch the automatic evaluation of wildcards or regular expression on and off in - LibreOffice Calc - Calculate.

warning

When using functions where one or more arguments are search criteria strings that represents a regular expression, the first attempt is to convert the string criteria to numbers. For example, ".0" will convert to 0.0 and so on. If successful, the match will not be a regular expression match but a numeric match. However, when switching to a locale where the decimal separator is not the dot makes the regular expression conversion work. To force the evaluation of the regular expression instead of a numeric expression, use some expression that can not be misread as numeric, such as ".[0]" or ".\0" or "(?i).0".


Syntax

DSTDEVP(Daatubeeze; DatabaseField; SearchCriteria)

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 (from the first row of Database range), place quotation marks around the header name.

Example

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.

The search supports wildcards or regular expressions. With regular expressions enabled, you can enter "all.*", for example to find the first location of "all" followed by any characters. If you want to search for a text that is also a regular expression, you must either precede every character with a "\" character, or enclose the text into \Q...\E. You can switch the automatic evaluation of wildcards or regular expression on and off in - LibreOffice Calc - Calculate.

warning

When using functions where one or more arguments are search criteria strings that represents a regular expression, the first attempt is to convert the string criteria to numbers. For example, ".0" will convert to 0.0 and so on. If successful, the match will not be a regular expression match but a numeric match. However, when switching to a locale where the decimal separator is not the dot makes the regular expression conversion work. To force the evaluation of the regular expression instead of a numeric expression, use some expression that can not be misread as numeric, such as ".[0]" or ".\0" or "(?i).0".


Syntax

DSUM(Daatubeeze; DatabaseField; SearchCriteria)

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 (from the first row of Database range), place quotation marks around the header name.

Example

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.

The search supports wildcards or regular expressions. With regular expressions enabled, you can enter "all.*", for example to find the first location of "all" followed by any characters. If you want to search for a text that is also a regular expression, you must either precede every character with a "\" character, or enclose the text into \Q...\E. You can switch the automatic evaluation of wildcards or regular expression on and off in - LibreOffice Calc - Calculate.

warning

When using functions where one or more arguments are search criteria strings that represents a regular expression, the first attempt is to convert the string criteria to numbers. For example, ".0" will convert to 0.0 and so on. If successful, the match will not be a regular expression match but a numeric match. However, when switching to a locale where the decimal separator is not the dot makes the regular expression conversion work. To force the evaluation of the regular expression instead of a numeric expression, use some expression that can not be misread as numeric, such as ".[0]" or ".\0" or "(?i).0".


Syntax

DVAR(Daatubeeze; DatabaseField; SearchCriteria)

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 (from the first row of Database range), place quotation marks around the header name.

Example

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.

The search supports wildcards or regular expressions. With regular expressions enabled, you can enter "all.*", for example to find the first location of "all" followed by any characters. If you want to search for a text that is also a regular expression, you must either precede every character with a "\" character, or enclose the text into \Q...\E. You can switch the automatic evaluation of wildcards or regular expression on and off in - LibreOffice Calc - Calculate.

warning

When using functions where one or more arguments are search criteria strings that represents a regular expression, the first attempt is to convert the string criteria to numbers. For example, ".0" will convert to 0.0 and so on. If successful, the match will not be a regular expression match but a numeric match. However, when switching to a locale where the decimal separator is not the dot makes the regular expression conversion work. To force the evaluation of the regular expression instead of a numeric expression, use some expression that can not be misread as numeric, such as ".[0]" or ".\0" or "(?i).0".


Syntax

DVARP(Daatubeeze; DatabaseField; SearchCriteria)

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 (from the first row of Database range), place quotation marks around the header name.

Example

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.

Please support us!