Calculating ratings across a range of cells

[John Blackwell]

I have a workbook with a row of 78 cells, each of which has a 1-5 rating. I need to calculate the number of cells that are rated 1, the number rated 2, and so on. I've tried using the formula =COUNTIF($E26:CD26,"1") and then dividing by 78 but this does not return the average rating.

How can I calculate the actual ratings for the 78 cells?

 

[RasGhul]

Hi John,

enter a number from 1-5 in cell B26, in C22 try

=COUNTIF($E$26:CD$26,B26)/COUNT($E$26:CD$26)

Alternatively list ratings 1 to 5 and then drag the formula down to suit.