How to sum cells based on multiple OR criteria | MS Excel Tutorial



There are few ways to sum values based on conditions. There are SUMIF and SUMIFS function let you to sum cells based on criteria across different columns. But what if you only want to sum cells based on multiple criteria in a column? Unfortunately SUMIF only let you sum cells based on one criteria and SUMIFS sum cells across columns but one criteria at a time. In this tutorial I will show how to use SUMIF, SUMIFS functions, and array formula to sum cells based on multiple criteria in a…

Leave a Reply

Your email address will not be published. Required fields are marked *