Find Occurrence Of Values In A Row In Excel

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.

Data table in which we want to count the items 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.

excel formula to count the occurrence of items in row

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.

formula has calculated the item frequencies in a row

Now drag the formula to the entire table to get the counts of each item in the rows.

drag the formula to entire table to count the occurrences in a row

As you could see our formula has calculated the occurrences of each item in a row.

Hope this helped.

Share The Knowledge

Random Posts

Leave a Reply