Forum Discussion
allen8106
Jan 30, 2019Copper Contributor
SUMIF for multiple requirements
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 mat...
SergeiBaklan
Jan 31, 2019Diamond Contributor
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