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
This should open up my argument window and my criteria is the only thing that’s going to change.
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.