SUMIF for multiple requirements

Copper Contributor

Hello, I'm working on a budget sheet want to use the SUMIF function to sum some data while applying two restrictions. First restriction is that the data must match the text in one column and then match a number in a different column.

 

Example:

Date          Description         Amount          Expense Month

1/30/19     Insurance            $1000.00         1

12/30/18   Insurance            $1000.00         2

1/30/19     Utilities                $500.00          1

 

I want to sum only the data for Insurance and January or month 1.

 

 

1 Reply