. . . . . . . . . . . .

Fungsi Basis Data

Bagian ini membahas fungsi yang digunakan dengan data yang diatur sebagai satu baris data untuk satu catatan.

note

Kategori Basis Data mungkin bingung dengan basis data yang terintegrasi dalam LibreOffice. Namun, tidak ada koneksi antara basis data dalam LibreOffice dan kategori Basis Data dalam LibreOffice Calc.


Contoh Data:

Data berikut akan digunakan dalam beberapa contoh deskripsi fungsi:

Rentang A1: E10 berisi daftar anak-anak yang diundang ke pesta ulang tahun Joe. Informasi berikut diberikan untuk setiap entri: kolom A menunjukkan nama, B kelas, kemudian usia dalam tahun, jarak ke sekolah dalam meter dan berat dalam kilogram.

A

B

C

D

E

1

-3,48

-10000

-3,48

Jarak ke Sekolah

-3,48

2

-3,48

3

9

150

40

3

-10000

4

10

1000

42

4

-3,48

3

10

300

51

5

-3,48

5

11

1200

48

6

-3,48

2

8

650

33

7

-10000

2

7

300

42

8

-10000

1

7

200

36

9

-10000

3

9

1200

44

10

-10000

2

8

1000

42

11

12

13

-3,48

-10000

-3,48

Jarak ke Sekolah

-3,48

14

>600

15

16

-3,48

5


Rumus dalam sel B16 adalah =DCOUNT(A1:E10;0;A13:E14)

Parameter Fungsi Basis Data:

Item berikut adalah definisi parameter untuk semua fungsi basis data:

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.

Pilih - LibreOffice Calc - Kalkulasi untuk menetapkan bagaimana LibreOffice Calc berakasi ketika mencari sebuah identik entri.

Lihat juga halaman Wiki tentang Penghitungan dan Penjumlahan Bersyarat

DAVERAGE

DAVERAGE mengembalikan nilai rata-rata dari semua sel (ruas) di semua baris (catatan basis data) yang cocok dengan kriteria pencarian yang ditentukan.

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".


Sintaksis

DAVERAGE(Basis Data; Bidang Isi Basis Data; Kriteria Pencarian)

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.

Contoh

Untuk mencari standar deviasi dari berat seluruh siswa berusia sama dalam contoh (gulung ke atas, mohon), masukkan rumus berikut pada B16:

=DAVERAGE(A1:E10;"Berat";A13:E14)

Di baris 14, di bawah Usia, masukkan 7, 8, 9, dan seterusnnya, satu demi satu. Berat rata-rata semua anak pada usia yang sama akan muncul.

DCOUNT

DCOUNT menghitung jumlah baris (catatan) dalam sebuah basis data yang sesuai dengan kondisi pencarian yang ditentukan dan berisi nilai numerik didalam kolom Ruas Basis Data.

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".


Sintaksis

DCOUNT(BasisData; [DatabaseField]; KriteriaPencarian)

Jika argumen DatabaseField dihilangkan, DCOUNT mengembalikan jumlah semua catatan yang memenuhi kriteria.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).

Contoh

Dalam contoh di atas (silakan gulir k atas), kami ingin tahu berapa banyak anak yang harus bepergian lebih dari 600 meter ke sekolah. Hasilnya disimpan di sel B16. Setel kursor di sel B16. Masukkan rumus =DCOUNT(A1:E10;D1;A13:E14)di B16. Fungsi Wizardmembantu kau untuk menginput rentang.

Basis Dataadalah kisaran data yang akan dievaluasi, termasuk tajuk-nya: dalam hal ini A1: E10. Ruas Basis Data menentukan kolom untuk kriteria pencarian: dalam kasus ini, kolom dengan nilai jarak numerik. Kriteria Pencariankisaran di mana anda dapat memasukkan parameter pencarian: dalam hal ini, A13: E14.

Untuk mempelajari berapa banyak anak di kelas dua yang berusia lebih dari 7 tahun, hapus entri > 600 di sel D14 dan masukkan2di sel B14 di bawah Kelas, dan masukkan >7 di sel C14 ke kanan. Hasilnya adalah 2. Dua anak berada di kelas dua dan lebih dari 7 tahun. Karena kedua kriteria berada di baris yang sama, keduanya terhubung oleh AND.

DCOUNTA

DCOUNTA menghitung jumlah baris (catatan) dalam basis data yang sesuai dengan kondisi pencarian yang ditentukan, dan berisi nilai numerik atau alfanumerik.

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".


Sintaksis

DCOUNTA(BasisData; [DatabaseField]; KriteriaPencarian)

Jika argumen Ruas Basis Data argument dihilangkan, DCOUNTA mengembalikan jumlah semua catatan yang memenuhi kriteria. 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).

Contoh

Pada contoh di atas (gulir ke atas), Anda dapat mencari banyaknya anak yang namanya berawalan dengan huruf E atau huruf berikutnya. Ubah rumus pada B16 untuk membaca =DCOUNTA(A1:E10;"Nama";A13:E14). Hapus kriteria pencarian yang lama dan Enter >=E di bawah Nama pada ruas A14. Hasilnya adalah 5. Jika Anda sekarang menghapus semua nilai angka untuk Greta di baris 8, hasil akan berubah menjadi 4. Baris 8 tidak lagi termasuk dalam hitungan karena tidak berisi nilai. Nama Greta adalah teks, bukan nilai. Perhatikan bahwa parameter DatabaseField harus menunjuk pada kolom yang berisi nilai.

DGET

DGET mengembalikan isi sel yang direferensikan dalam basis data yang cocok dengan kriteria pencarian yang ditentukan. Jika terjadi kesalahan, fungsi mengembalikan #VALUE! tanpa baris ditemukan, atau Err502 untuk lebih dari satu sel ditemukan.

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".


Sintaksis

DGET(Basis Data; Bidang Isi Basis Data; Kriteria Pencarian)

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.

Contoh

Dalam contoh di atas (silakan, gulir ke atas), kami ingin menentukan berapa nilai seorang anak, yang namanya dimasukkan dalam sel A14. Rumus dimasukkan dalam sel B16 dan sedikit berbeda dari contoh sebelumnya karena hanya satu kolom (satu ruas basis data) yang dapat dimasukkanRuas Basis Data. Masukkan rumus berikut:

=DGET(A1:E10;"Grade";A13:E14)

Masukkan Nama Frank di A14, dan Anda melihat hasilnya 2. Frank di kelas dua. Memasukkan "Usia" bukannya "Kelas" dan Anda akan mendapatkan usia Frank:

Atau masukkan nilai 11 hanya di sel C14, dan hapus masukkan di baris lainnya. Ubah formula di B16 sebagai berikut:

=DGET(A1:E10;"Nama";A13:E14)

dari pada kelas, nama dipertanyakan. Jawabannya muncul sekali: Daniel adalah satu-satunya anak berusia 11 tahun.

DMAX

DMAX mengembalikan konten maksimal sebuah sel (ruas) pada basis data (semua catatan) yang sesuai dengan kondisi pencarian yang ditentukan.

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".


Sintaksis

DMAX(Basis Data; Bidang Isi Basis Data; Kriteria Pencarian)

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.

Contoh

Untuk mencari tahu anak terberat di setiap tingkat, ditimbang dalam contoh diatas (gulir ke atas) masukkan rumus berikut dalam B16:

=DMAX(A1:E10;"Berat";A13:E14)

Dibawah Kelas, masukkan 1, 2, 3 dan seterusnya, satu demi satu. Setelah memasukkan nomor kelas, berat anak terberat di kelas itu muncul.

DMIN

DMIN mengembalikan konten minimum sel (ruas) dalam basis data yang cocok dengan kriteria pencarian yang ditentukan.

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".


Sintaksis

DMIN(Basis Data; Bidang Isi Basis Data; Kriteria Pencarian)

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.

Contoh

Untuk menemukan jarak terpendek ke sekolah untuk anak-anak di setiap kelas dalam contoh di atas (silakan, gulir ke atas), masukkan rumus berikut di B16:

=DMIN(A1:E10;"Jarak ke Sekolah";A13:E14)

Di baris 14, dibawah Kelas, masukkan 1, 2, 3 dan seterusnya, satu demi satu. Jarak terpendek ke sekolah untuk setiap kelas muncul.

DPRODUCT

DPRODUCT mengalikan semua sel rentang data di mana konten sel sesuai dengan kriteria pencarian.

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".


Sintaksis

DPRODUCT(Basis Data; Bidang Isi Basis Data; Kriteria Pencarian)

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.

Contoh

Dengan contoh pesta ulang tahun di atas (silakan gulir ke atas), tidak ada fungsi yang berarti pada aplikasi ini.

DSTDEV

DSTDEV menghitung standar deviasi populasi berdasarkan sampel, menggunakan angka-angka dalam kolom basis data yang sesuai dengan kondisi yang diberikan. Catatan diperlakukan sebagai sampel data. Itu berarti bahwa anak-anak dalam contoh mewakili suatu penampang dari semua anak. Perhatikan bahwa hasil representatif tidak dapat diperoleh dari sampel kurang dari seribu.

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".


Sintaksis

DSTDEV(Basis Data; Bidang Isi Basis Data; Kriteria Pencarian)

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.

Contoh

Untuk mencari standar deviasi dari berat seluruh siswa berusia sama dalam contoh (gulung ke atas, mohon), masukkan rumus berikut pada B16:

=DSTDEV(A1:E10;"Berat";A13:E14)

Pada baris 14, dibawah Umur, masukkan 7,8,9, dan seterusnya, satu demi satu. Hasil yang ditunjukkan adalah standar deviasi berat semua anak pada usia ini.

DSTDEVP

DSTDEVP menghitung standar deviasi populasi berdasarkan rentang data semua sel yang sesuai dengan kriteria pencarian.Catatan dari contoh diperlakukan sebagai seluruh populasi.

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".


Sintaksis

DSTDEVP(Basis Data; Bidang Isi Basis Data; Kriteria Pencarian)

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.

Contoh

Untuk mencari standar deviasi dari berat seluruh siswa berusia sama dalam contoh (gulung ke atas, mohon), masukkan rumus berikut pada B16:

=DSTDEVP(A1:E10;"Berat";A13:E14)

Di baris 14, di bawah Usia, masukkan 7, 8, 9, dan seterusnya, satu demi satu. Hasilnya adalah standar deviasi berat badan untuk semua anak yang berumur sama yang diperiksa beratnya.

DSUM

DSUM mengembalikan jumlah keseluruhan dari semua sel di ruas basis data dalam semua baris (catatan) yang sesuai dengan kriteria pencarian yang ditentukan.

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".


Sintaksis

DSUM(Basis Data; Bidang Isi Basis Data; Kriteria Pencarian)

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.

Contoh

Untuk mencari panjangnya jarak ke sekolah yang terkombinasi dari seluruh anak kelas dua pada ulang tahun Joe's (silahkan, gulir ke atas), masukkan rumus berikut dalam B16:

=DSUM(A1:E10;"Jarak ke Sekolah";A13:E14)

Masukkan 2baris 14 di bawah Kelas. Totalnya (1950) dari jarak ke sekolah untuk semua anak-anak yang berada di kelas dua ditampilkan.

DVAR

DVAR mengembalikan varian dari semua ruas sel basis data di semua catatan yang cocok dengan kriteria pencarian yang ditentukan.Catatan dari contoh diperlakukan sebagai sampel data. Hasil representatif tidak dapat diperoleh dari populasi sampel kurang dari seribu.

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".


Sintaksis

DVAR(Basis Data; Bidang Isi Basis Data; Kriteria Pencarian)

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.

Contoh

Untuk mencari standar deviasi dari berat seluruh siswa berusia sama dalam contoh (gulung ke atas, mohon), masukkan rumus berikut pada B16:

=DVAR(A1:E10;"Berat";A13:E14)

Di baris 14, di bawah Usia, masukkan 7, 8, 9 dan seterusnya, satu demi satu. Anda bisa melihat hasil variasi nilai berat dari usia semua anak.

DVARP

DVARP menghitung variasi dari semua nilai sel dalam ruas basis data di semua catatan yang sesuai dengan kriteria pencarian yang ditentukan.Catatan tersebut dari contoh diperlakukan sebagai seluruh populasi.

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".


Sintaksis

DVARP(Basis Data; Bidang Isi Basis Data; Kriteria Pencarian)

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.

Contoh

Untuk mencari standar deviasi dari berat seluruh siswa berusia sama dalam contoh (gulung ke atas, mohon), masukkan rumus berikut pada B16:

=DVARP(A1:E10;"Berat";A13:E14)

Di baris 14, di bawah Usia, masukan 7, 8, 9, dan seterusnya, satu demi satu. Memunculkan varian dari nilai berat untuk semua anak di usia ini yang menghadiri pesta ulang tahun Joe.

Mohon dukung kami!