Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Using countif to see if any values are added
Dear friends on MS,
I have a column in which I enter data. At the end of the column, I want to see how many fields in the column do have data in them. I was thinking of using =COUNTIF(B3:B43,"?"), but it gives me an entry of 0, where I know data has been entered in some of the fields. How should I tackle this? -- ** Fool on the hill ** |
#2
|
|||
|
|||
"Jaydubs" wrote in message
... I have a column in which I enter data. At the end of the column, I want to see how many fields in the column do have data in them. I was thinking of using =COUNTIF(B3:B43,"?"), but it gives me an entry of 0, where I know data has been entered in some of the fields. How should I tackle this? =COUNTA(B3:B43) Rgds, Andy |
#3
|
|||
|
|||
Great,
This answers my question, Thanx mate ! "Andy Brown" wrote: "Jaydubs" wrote in message ... I have a column in which I enter data. At the end of the column, I want to see how many fields in the column do have data in them. I was thinking of using =COUNTIF(B3:B43,"?"), but it gives me an entry of 0, where I know data has been entered in some of the fields. How should I tackle this? =COUNTA(B3:B43) Rgds, Andy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating an EXCEL COUNTIF formula for a range of values | Excel Discussion (Misc queries) | |||
Second serie doesn't use X-as values | Charts and Charting in Excel | |||
Countif between two values | Excel Worksheet Functions | |||
Countif - Countif | Excel Worksheet Functions | |||
Countif ??? | Excel Worksheet Functions |