In this post we will see how to find the occurrence of an item in a row.
We require these kind of excel operations to show the counts and occurrence of an item in table or aggregated form.
Counting the occurrence of an item in a column in very common, and in this post we will see hot to replicate the same to count the occurrence of an item in a row.
Here is the example data with the name of fruits and we want to get the count of occurrence of the fruits in table in column I.J and K.
We will use the excel formula COUNTIF to count the occurrence of items in a row.
Enter the formula =COUNTIF($A2:$E2,I$1) , in the cell I2 as shown in the figure below.
As you could see in the formula, I have fixed the reference for columns in our data range and have fixed the reference for rows as we want to count the frequencies of items that are there in row 1 of column I,J and K.
COUNTIF formula has two arguments, first is the range in which our data is present which is A2:E2 in our data and the second argument is criteria which defines the value that we want to look for in our data range in first argument.
Press enter after entering the formula and it will give you the count of Apple in row 2.
Now drag the formula to the entire table to get the counts of each item in the rows.
As you could see our formula has calculated the occurrences of each item in a row.
Hope this helped.