countif

[Tomo]

what I am trying to do is count a cell only if it is not blank dont want to use specific text I can do that but am drawing a blank if you excuse the pun on the formula for doing this.

so it the cell a1 is blank ignore it anything else give it a value of 1

thanks in advance

 

[villy]

Try...

CountIf(Range,Criteria)

 

[Tomo]

i use countif=(monday!a1,"")

but it is not working need it to count the cell only if there is text in it not if it's blank

 

[villy]

Supposed...

=CountIf(A$2:A$10,">0")

 

[Tomo]

That works fine for a number value but it is text in the cell so need it to count if there is any text in the cell

what i need is if cell a1 = fred count as 1

 

[villy]

=CountA(A2:A10) For Text and
=Count(A2:A10) For Numbers

 

[Tomo]

32 has the text fred in it

=COUNTA(E32,">0")

This formula gives me the value 2

any ideas should be 1

 

[villy]

Use only
=CountA(E32)

 

[Tomo]

GREAT thanks a lot

 

[villy]

Welcome