Calculating ratings across a range of cells

John Blackwell

New Member
Joined
Feb 3, 2013
Messages
10
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?
 

Some videos you may like

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

RasGhul

Well-known Member
Joined
Jul 15, 2016
Messages
609
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,044
Messages
5,466,207
Members
406,473
Latest member
Dunno123

This Week's Hot Topics

Top