You have a dataset that contains people and the awards they have won.
Which formula should you use to get the number of people who won an award?
You have a dataset that contains people and the awards they have won.
Which formula should you use to get the number of people who won an award?
To get the number of people who won an award, you need a formula that counts the unique names in the dataset. Since some individuals have won more than one award, they will appear multiple times in the list. The COUNTD([Name]) function counts distinctive or unique names, ensuring each person is counted only once regardless of the number of awards they have won.
Answer is correct. You need the distinct count because some winners appear more than once.