G
Guest
Hi,
I was checking one of the formula that appears as example:
{=SUM(IF($A1:$A20>=8,1,0))}
This is done by someone and the value return to 20 since all the cell have a
9 on it. But if I edit this cell, the { } will go away. and will give me the
#VALUE! message in the cell. can anyone tell me how I can add this?
I was checking one of the formula that appears as example:
{=SUM(IF($A1:$A20>=8,1,0))}
This is done by someone and the value return to 20 since all the cell have a
9 on it. But if I edit this cell, the { } will go away. and will give me the
#VALUE! message in the cell. can anyone tell me how I can add this?