Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF forumla help | Excel Discussion (Misc queries) | |||
is it possible for Vlookup and CountIf function in the same forumla? | Excel Discussion (Misc queries) | |||
IF Forumla help | Excel Discussion (Misc queries) | |||
Forumla Help!countif?IF?If(AND? if(OR? | Excel Discussion (Misc queries) | |||
Forumla Help | Excel Discussion (Misc queries) |