Now I want to get the counts, I want to know how many sales we’re done with the category of SUPPLIES.
At J9 cell, I’m get a count of the sales column where the category is equal to supplies.
I’m going to use the DCOUNT function because I’m going to be counting the total sales.
There is four entries in here and we counted for total sales values for the supplies category. It’s all built directly into the calculation.
Just watch for that little tip and make sure things are spelled properly, they match what’s in the data.