Countif, Countifs, Sumif, Sumifs in Google Sheets

Countif, Countifs, Sumif, Sumifs in Google Sheets

COUNTIF, COUNTIFS, SUMIF, and SUMIFS are useful functions in Google Sheets for counting or summing data based on specific criteria. Here's an overview of each function:

1. COUNTIF: This function counts the number of cells within a range that meet a specified criterion. The basic syntax is:

=COUNTIF(range, criterion)

The "range" argument is the range of cells you want to count, and the "criterion" argument is the condition that cells must meet to be counted.


2. COUNTIFS: This function counts the number of cells within multiple ranges that meet multiple criteria. The basic syntax is:

=COUNTIFS(range1, criterion1, [range2, criterion2,...])

The "range1" argument is the first range of cells you want to count, and the "criterion1" argument is the condition that cells in that range must meet to be counted. You can specify up to 127 additional ranges and criteria to count.


3. SUMIF: This function calculates the sum of cells within a range that meet a specified criterion. The basic syntax is:

=SUMIF(range, criterion, [sum_range])

The "range" argument is the range of cells you want to evaluate for the criterion, the "criterion" argument is the condition that cells must meet to be summed, and the "sum_range" argument is the range of cells you want to sum.


4. SUMIFS: This function calculates the sum of cells within multiple ranges that meet multiple criteria. The basic syntax is:

=SUMIFS(sum_range, range1, criterion1, [range2, criterion2,...])

The "sum_range" argument is the range of cells you want to sum, the "range1" argument is the first range of cells you want to evaluate for the criteria, and the "criterion1" argument is the condition that cells in that range must meet to be included in the sum. You can specify up to 127 additional ranges and criteria to sum.

Here's an example of how to use the COUNTIF function in Google Sheets to count the number of cells in a range that contain the text "apple":

=COUNTIF(A1:A10, "apple")

In this example, the formula counts the number of cells in the range A1:A10 that contain the text "apple".

And here's an example of how to use the SUMIFS function in Google Sheets to calculate the sum of sales for a particular product and month:

=SUMIFS(D2:D10, B2:B10, "Apples", C2:C10, "January")

In this example, the formula sums the values in the range D2:D10 (the sales) where the corresponding cells in the range B2:B10 contain "Apples" and the cells in the range C2:C10 contain "January".