Using COUNTIF forumla
 

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

Using COUNTIF forumla
 

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

Using COUNTIF forumla
 

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

Using COUNTIF forumla
 

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