Counting Cells in Excel with a certain number or higher....help

[SteveAudus]

I have a excel sheet with some numbers in the
cells, I would like a column telling how many
cells in that row contain a number of five
or more:


A | B | C | D | E | F | G | =>5
1 4 5 6 2
3 3 5 1 1 1
1 3 2 2 1
4 4 5 7 1 2

Could some please tell me the formula,
for my (How many 5 or more column)

Thank you very much for any help,
Steve Audus
Chaucer Community School
Sheffield
UK

 

[tomschafer]

Drag and drop this as nescessary for rows below 1. Also add any nescessary columns.

=IF(A1>=5,1,0)+IF(B1>=5,1,0)+IF(C1>=5,1,0)+IF(D1>=5,1,0)+IF(E1>=5,1,0)+IF(F1>=5,1,0)+IF(G1>=5,1,0)

 

[Guest_imported]

Cheers,
Pezamystik
that worked lovely

 

[BenUK]

Why not just use the CountIf function.

=CountIf(A1:A5,">5&quot

This will count all cells in the specified range that are of a value greater than 5