Skip to content

The COUNT and SUM Functions

Of the many functions available in spreadsheets, two of the most popular are the COUNT function and the SUM function.

These two functions do what you might expect. The COUNT function counts the number of cells that contain numbers. The SUM function adds up all the numbers in a range of cells.

More About the COUNT Function

As mentioned before, the COUNT function counts the number of cells that contain numbers.

For example, the following function counts how many numbers are in the referenced range.

The COUNTIF Function

If you want to count cells based on one criterion (instead of how many numbers there are), you can use the COUNTIF function.

This function looks at the referenced range and counts how many cells match a specific condition.

For instance, if you want to count how many cells contain numbers greater than 10, you’d use the COUNTIF function shown below.

 

Here is another example. This example counts how many cells contain the text value “red.”

The COUNTIFS Function

The COUNTIFS function is just like the COUNTIF function. The only difference is that you can count rows based on multiple criteria.

For example, here is how you would count how many rows contain a value greater than 10 and the text value “red.”

More About the Sum Function

The SUM function adds up all the numbers in a range of cells.

For example, the following function sums all the numbers in the referenced range.

The SUMIF Function

If you want to sum cells based on one criterion, you can use the SUMIF function.

For instance, if you want to sum the cells with numbers greater than 10, you’d use the SUMIF function shown below.

 

Here is another example. This example sums the cells next to cells with the text value “red.”

The SUMIFS Function

The SUMIFS function is just like the SUMIF function. The only difference is that you can sum cells based on multiple criteria.

For example, here is how you would sum the cells that contain a value greater than 10 and next to the text value “red.”

 

And this about covers the basics of the SUM and COUNT functions!

This Post Has 0 Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top