SUMIF for multiple requirements

Question

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.&nbsp;Example:Date&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Description&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Amount&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Expense Month1/30/19&nbsp; &nbsp; &nbsp;Insurance&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $1000.00&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;112/30/18&nbsp; &nbsp;Insurance&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $1000.00&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;21/30/19&nbsp; &nbsp; &nbsp;Utilities&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $500.00&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp;I want to sum only the data for Insurance and January or month 1.&nbsp;&nbsp;

sergeibaklan · Answer

Hi,
&nbsp;
For multiple criteria you may use SUMIFS&nbsp;https://support.office.com/en-us/article/sumifs-function-c9e748f5-7ea7-455d-9406-611cebce642b or SUMPRODUCT&nbsp;https://exceljet.net/excel-functions/excel-sumproduct-function

Forum Discussion

SUMIF for multiple requirements

1 Reply