Topik terkait
×
Average a group of numbers
Masuk dengan Microsoft
Masuk atau buat akun.
Halo,
Pilih akun lain.
Anda memiliki beberapa akun
Pilih akun yang ingin Anda gunakan untuk masuk.
Bahasa Inggris
Maaf. Artikel ini tidak tersedia dalam bahasa Anda.
Average a group of numbers

Average a group of numbers

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

You may have used AutoSum to quickly add numbers in Excel. But did you know you can also use it to calculate other results, such as averages?

Use AutoSum to quickly find the average

AutoSum lets you find the average in a column or row of numbers where there are no blank cells.

  1. Click a cell below the column or to the right of the row of the numbers for which you want to find the average.

  2. On the HOME tab, click the arrow next to AutoSum > Average, and then press Enter.

Want more?

Calculate the average of a group of numbers

AVERAGE function

AVERAGEIF function

Perlu bantuan lainnya?

Ingin opsi lainnya?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Apakah informasi ini berguna?

Apa yang memengaruhi pengalaman Anda?
Dengan menekan kirim, umpan balik Anda akan digunakan untuk meningkatkan produk dan layanan Microsoft. Admin TI Anda akan dapat mengumpulkan data ini. Pernyataan Privasi.

Terima kasih atas umpan balik Anda!

×