10 RUMUS DASAR EXCEL

Hai sahabat excel..

Gimana kabarnya???????

Udah lamaaaaaaa banget nggk update artikel seputar excel..

Nah, kali ini admin akan membagikan pengetahuan lagi nih..

Yok Simak..

1. Rumus Penjumlahan

1. =4+4
2. =SUM(4+4)
3. =SUM(3,3,5,)
4. =SUM(A3:A5)

2. Rumus Minimum

1. =MIN(2,4,6,7,3,1)
2. =MIN(C3:C5)

3. Rumus Maximum

1. =MAX(E3:E5)

4. Rumus Rata-rata

1. =AVERAGE(4,4,4,4,4,4,4,4,4,4)
2. =AVERAGE(G3:G4)

5. Rumus Logika IF

1. =IF(A13=1,"LAKI-LAKI","PEREMPUAN")
2. =IF(C10=1,"RUGI",IF(C10=2,"UNTUNG",""))

6. Rumus COUNT

1. =COUNT(4,5,6,3,3,3,3,3,)
2. =COUNT(E11:E13)

7. Rumus COUNTA

1. =COUNTA(F,3,D,3,D,3,4)

8. Rumus COUNTIFS

1. =COUNTIFS(B23:B26,"L",C23:C26,"<16 li="">
2. =COUNTIFS(B23:B26,"L",C23:C26,">=16")+COUNTIFS(B23:B26,"P",C23:C26,">=16")

9. Rumus SUMIFS

1. =SUMIFS(C33:C40,B33:B40,"L",C33:C40,">=20000")

10. Rumus SUMIF

1. =SUMIF(K33:L40,"L",L33:L40)

Demikian ya sobat 10 Rumus Dasar Excel yang sering kita gunakan dikantoran..

Semoga bermanfaat..

Download File 10 Rumus Dasar Excel

"Kami Selalu Berusaha Memberikan Yang Terbaik Dan Original Untuk Anda"

Jabat Erat@Hak Cipta 2015

Share :