Hi,

The quotes around the 6 make it text so sum won't add them up

=IF(AND(J30,J3<6),J3+1,6)

Note I've also changed the formula to a more understandable format.

Mike

"Noddy2011" wrote:

My formula is =IF(AND(0<J3,J3<6),J3+1,"6") but when i use sum to add the
cells together is doesn't count any cell with "6" in. Why is this and how do
i change this please.