Might want to read a book on Excel functions.

Good luck

Tyro

"Robin1979" wrote in message
...
Hey David, that's great thank you! I was barking up the wrong tree!

"David Biddulph" wrote:

COUNTA ?
--
David Biddulph

"Robin1979" wrote in message
...
Hello, I'm sure there is a very easy answer to this...

For various cells within my sheet I want to use a COUNTIF formula to
total
up the number of entries held within these cells. The entires are not
going
to be same within each of the cells.

So basically if the cell has a text entry that needs to be counted as 1
value is there anyway around this?

Thanks
Robin