Home / Excel Basics / 14.2 Excel DSUM Function with OR Criteria

14.2 Excel DSUM Function with OR Criteria

We’ve got a single bit of criteria we’re summing up the total sales column where the category column is equal to “Rent”.

What if you wanted to do I want to get a sum of the category for rent and or I want to get it for overhead so give me rents some including overhead.

Now, we’re looking for multiple criteria. multiple criteria in a single column sum up where category is equal to RENT or it’s equal to SOFTWARE. this is really easy to do with this DSUM function.

What I want now is I want criteria is rent or software.

I’m going to click on that cell, I’m going I’m going to hit the little fx button

Excel DSUM Function with OR Criteria 1

This should open up my argument window and my criteria is the only thing that’s going to change.

Excel DSUM Function with OR Criteria 2

Hit OK and I’ve now got both of those categories in that total sum of total sales, got both of them in cell J3.

This is called an overstatement, this happens when you have multiple criteria on a single column, header on the top. Try this one out OR criteria inside of DSUM function.

About admin

Check Also

Excel DSUM Function with AND Criteria 1

14.3 Excel DSUM Function with AND Criteria

We’ve seen a single criteria where we’re getting where category is equal to rent, and …

Leave a Reply

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