Home / Tech / Excel Basics / 14.5 Excel Function: DCOUNT()

14.5 Excel Function: DCOUNT()

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.

Excel Function DCOUNT

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.

About admin

Check Also

Excel Decimal Data Validation 1

15.2 Excel Decimal Data Validation

Create the little dropdown give the users the exact values for them to pick from. …

Leave a Reply

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