analisis data 2

Cherish Davelyne Setiawan 9f/04

sheet 1

1.rumus nama lengkap

 =CONCATENATE(B5;C5)

2.Rumus jumlah karakter

=LEN(D10)

3.Rumus kolom kosong

=COUNTA(B15)

Sheet 2

1. Rumus total harga

=SUMIGS($C$5:$C$14;$B$5:$B$14;$F$5)

2. Rumus rata rata harga

=AVERAGEIFS(D5:D14;B5:B14;F5)

3. Rumus units

=COUNTIFS(B5:B14;F5)