
10.5K
HEFunction DCount application 🤩
.
Function Dcount enables us to count number of data using multiple criterias in large volume of data.
.
In this example, We wanna find the number of employees having certain years of experience within a department.
.
I.e. we are using two criterias viz Department and Experience.
.
Criterias need to be provided in cell references along with their label/heading.
.
In Database as well, labels should be mentioned immediately followed by the data.
.
Do try and let me know if you like it. 👍🏻
.
PS:
➡️ Version Used: Excel 2019.
➡️ There can be multiple approaches to do a single thing. Hence EXAMPLES have been designed JUST TO SHOW the application of concerned topic.
.
(Microsoft Excel, MS Excel, MS Excel Tutorial, Excel Tutorial, MS Excel Video, Excel Video, Microsoft Excel Videos, Spreadsheet, Google Sheet, MS Excel Tips and Tricks, Learn Excel, Commerce, Accounting, Finance, Data Analysis, Data Analytics, Data Manipulation, Productivity Hacks)
.
#microsoft365 #microsoft #excel #exceltips #exceltricks #tutorial #workhacks #spreadsheets #corporate #accounting #finance
@helloexcelbydeepika










