I can get it to partially work with this

=COUNTIF(C9:I25,"=39")

But am unable to put a range in cell by cell. Maybe someone else can assist
here.

"R.P.McMurphy" wrote in message
...
HI all, I have six cells; c9,c17,c25,j9,j17,j25

if the number entered in any of these cells is over 39 then I want to
total the number over that amount. is that clear? for example-

cell c9 has 30
cell c17 has 39
cell c25 has 40
cell j9 has 23
cell j17 has 42
cell j25 has 2

the answer would be 3

Any help gratefully received! (again)

Steve