Skip to main content

How to Use the SUM, AVERAGE, and COUNT Functions in Google Sheets

How to Use the SUM, AVERAGE, and COUNT Functions in Google Sheets

How to Use the SUM, AVERAGE, and COUNT Functions in Google Sheets

Google Sheets makes it easy to work with numbers and data. Three of the most fundamental functions are SUM, AVERAGE, and COUNT. Whether you're calculating totals, averages, or counting entries, mastering these functions is essential for any spreadsheet user.

🔢 1. The SUM Function

The SUM function adds up a series of numbers. It's a powerful and simple tool to calculate totals in Google Sheets. To use it, enter the following formula:

=SUM(A1:A10)

This will add all the numbers in the range from A1 to A10. You can also use SUM with multiple ranges:

=SUM(A1:A10, C1:C10)

📊 2. The AVERAGE Function

The AVERAGE function calculates the mean of a group of numbers. This is useful when you want to find the average of a dataset. The syntax for the AVERAGE function is:

=AVERAGE(A1:A10)

This will return the average of the numbers in cells A1 through A10. Similar to SUM, AVERAGE can handle multiple ranges too:

=AVERAGE(A1:A10, C1:C10)

✅ 3. The COUNT Function

The COUNT function counts the number of cells in a range that contain numerical values. For example:

=COUNT(B1:B10)

This will count how many cells in the range B1 to B10 have numbers. If you want to count non-empty cells regardless of their content type (not just numbers), you can use the COUNTA function:

=COUNTA(B1:B10)

📊 Examples of Usage

Let’s go over some practical examples:

  • SUM Example: You have a list of expenses in column A, and you want to calculate the total amount. Simply use =SUM(A1:A20).
  • AVERAGE Example: You want to calculate the average sales in column B for the past month. Use =AVERAGE(B1:B30).
  • COUNT Example: To count the number of entries in a column, use =COUNT(C1:C50).

📥 Downloadable PDF

Tags: SUM function, AVERAGE function, COUNT function, Google Sheets tutorial, Google Sheets formulas

Comments

Post a Comment

Popular posts from this blog

How to activate office 2016 using script ??

How to activate office 2016 using script ?? 1. Copy the following script in notepad and save as .bat . 2. Run the bat file as administrator. @echo off title Permanently Activate Office 365 ProPlus for FREE - Somethingos.blogspot.incom&cls&echo ============================================================================&echo #Project: Activating Microsoft software products without software&echo ============================================================================&echo.&echo #Supported products: Office 365 ProPlus (x86-x64)&echo.&echo.&(if exist "%ProgramFiles%\Microsoft Office\Office16\ospp.vbs" cd /d "%ProgramFiles%\Microsoft Office\Office16")&(if exist "%ProgramFiles(x86)%\Microsoft Office\Office16\ospp.vbs" cd /d "%ProgramFiles(x86)%\Microsoft Office\Office16")&(for /f %%x in ('dir /b ..\root\Licenses16\proplusvl_kms*.xrm-ms') do cscript ospp.vbs /inslic:"..\root\Licenses16...
2 comments
Read more

How to break Windows password using Ubuntu?

How to break Windows password using Ubuntu? 1. Boot machine with Ubuntu and run as live. 2. Open Terminal, set root password and switch user as root in terminal. 3. Install  chntpw   graphically or by using command           #apt-get install chntpw                       or           #apt install chntpw 4. Create a directory with any name.           #mkdir /abc 5. Mount C drive to abc directory.             #ntfs-3g mount /dev/sda1 /abc -o force 6. locate sam file             #cd /abc/Windows/System32/config 7. use command:             #chntpw -l                   //to list users             #chntpw -u administrator sa...
Post a Comment
Read more

Using Conditional Formatting to Highlight Data in Google Sheets

Using Conditional Formatting to Highlight Data in Google Sheets Using Conditional Formatting to Highlight Data in Google Sheets Conditional formatting in Google Sheets is a powerful tool that lets you apply custom formatting to cells based on specific conditions. Whether you're highlighting overdue tasks, flagging high expenses, or marking duplicates, conditional formatting makes your data visually informative and easier to analyze. 🎯 What is Conditional Formatting? Conditional formatting allows you to change the appearance of cells in your spreadsheet based on rules you define. For example, you can highlight all numbers greater than 100, mark dates in red if overdue, or use color scales to visualize data distribution. 📌 How to Apply Conditional Formatting in Google Sheets Select the range of cells you want to format. Click on Format > Conditional formatting . In the right panel, choose your condition (e.g., "Greater th...
Post a Comment
Read more