Revision history [back]

To combine multiple conditions using an array formula and sumif function in Google Sheets, follow these steps:

1. Open your Google Sheet and select the cell where you want to display the result.

2. In the formula bar, enter the following formula: =SUM(IF((condition1)* (condition2)* (conditionN), value_range))

Note: Replace "condition1", "condition2", and "conditionN" with the conditions you want to combine, and "value_range" with the range of cells you want to sum.

1. Press Ctrl + Shift + Enter to apply the formula as an array formula.

2. The result will be displayed in the selected cell.

For example, suppose you want to sum the values in column A where the corresponding values in column B are "Apples" and the corresponding values in column C are "2022". You can use the following formula:

=SUM(IF((B:B="Apples")*(C:C=2022),A:A))

Note: The asterisk (*) symbol is used to signify "AND" for combining the conditions.