00:00Count the number of occurrence of an item in your list like this using one simple formula. Ready?
00:06Let's go. The function that we're going to use is called group by. The first argument in there
00:11would be your row fields where your group by is going to act on which is going to be your
00:16produce
00:16sole. And then the second argument is also known as the values yourself. The values that the
00:23aggregation function is going to act on which is again going to be same as the first argument
00:28which is going to be the produce sole itself. And the third argument is going to be your function
00:33or the aggregation function name for our intents and purpose is going to be count a. Count a is a
00:40function that counts cells containing any type of information including error values. The only thing
00:45that count a function does not count is empty cell. Let's close parenthesis this group by function and
00:52hit enter and voila there you go. This is how you count the number of occurrence of an item in
00:58your
00:58data set list.
