Jan 30 2019 11:43 AM
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.
Jan 31 2019 01:50 AM
Hi,
For multiple criteria you may use SUMIFS https://support.office.com/en-us/article/sumifs-function-c9e748f5-7ea7-455d-9406-611cebce642b or SUMPRODUCT https://exceljet.net/excel-functions/excel-sumproduct-function