Google Sheets Function: SUMIFS

The SUMIFS function allows for summing a range of cells based on multiple criteria (unlike the SUMIF function which is limited to a single criterion).


=SUMIFS(sum_range, criteria_range1, criterion1)


=SUMIFS(sum_range, criteria_range1, criterion1, criteria_range2, criterion2, ...)

Usage Example

The SUMIFS function will be used here to first calculate the sum of unpaid amounts (= 1 criterion) and then the sum of overdue unpaid amounts (= 2 criteria):

google sheets sum unpaid sumifs

Enter into the SUMIFS function:

The formula is as follows:

google sheets sumifs blank
The SUMIF function could also have been used to perform this sum with a single condition (however, be aware that the order of arguments is not the same with this function).

To obtain the sum of overdue unpaid amounts, add a second criterion to the formula that checks if the payment deadline has passed (thus earlier than TODAY):

google sheets sumifs date today
If needed, you can copy the Google Sheets document (or view the document) with this example.
Tip: it is possible to use wildcard characters with this function.