I would like to count the text in a column, (each text would count as 1), the
column contains a simple "If" statement that will return either a name or a
blank. The text counting solutions I see in these posts also count the If
statement as 1.

=COUNTA(M2:M20)-COUNTBLANK(M2:M20)

--
__________________________________
HTH

Bob

"Paul H" <(E-Mail Removed)> wrote in message
news:147A55BA-4B87-48C9-B767-(E-Mail Removed)...
>I would like to count the text in a column, (each text would count as 1),
>the
> column contains a simple "If" statement that will return either a name or
> a
> blank. The text counting solutions I see in these posts also count the If
> statement as 1.

If A1 thru A10 contain either text or formulas returning a blank, then:

=COUNTA(A1:A10)-COUNTBLANK(A1:A10)

--
Gary''s Student - gsnu200800


"Paul H" wrote:

> I would like to count the text in a column, (each text would count as 1), the
> column contains a simple "If" statement that will return either a name or a
> blank. The text counting solutions I see in these posts also count the If
> statement as 1.

Gary and Bob, your solution is counting the "If" statement in the cells. I
have 1 name (Text) and 30 blank cells and your formula returns 31?


"Gary''s Student" wrote:

> If A1 thru A10 contain either text or formulas returning a blank, then:
>
> =COUNTA(A1:A10)-COUNTBLANK(A1:A10)
>
> --
> Gary''s Student - gsnu200800
>
>
> "Paul H" wrote:
>
> > I would like to count the text in a column, (each text would count as 1), the
> > column contains a simple "If" statement that will return either a name or a
> > blank. The text counting solutions I see in these posts also count the If
> > statement as 1.

The solution the Bob & I proposed will work for a block of cells none of
which are truly empty; that is they all will have text showing or have a
formula returning a blank.

If this is not the case and the block of cells has both cells with visible
text and cells that are truly empty, then just use the COUNTA() function.
--
Gary''s Student - gsnu200800


"Paul H" wrote:

> Gary and Bob, your solution is counting the "If" statement in the cells. I
> have 1 name (Text) and 30 blank cells and your formula returns 31?
>
>
> "Gary''s Student" wrote:
>
> > If A1 thru A10 contain either text or formulas returning a blank, then:
> >
> > =COUNTA(A1:A10)-COUNTBLANK(A1:A10)
> >
> > --
> > Gary''s Student - gsnu200800
> >
> >
> > "Paul H" wrote:
> >
> > > I would like to count the text in a column, (each text would count as 1), the
> > > column contains a simple "If" statement that will return either a name or a
> > > blank. The text counting solutions I see in these posts also count the If
> > > statement as 1.

Don't know what going on, your suggested formula doesn't work, the "If"
statements is =IF(B17=0,C18," ") the formula counts this cell even when the
results are blank, is my If statement causing the problem?


"Gary''s Student" wrote:

> The solution the Bob & I proposed will work for a block of cells none of
> which are truly empty; that is they all will have text showing or have a
> formula returning a blank.
>
> If this is not the case and the block of cells has both cells with visible
> text and cells that are truly empty, then just use the COUNTA() function.
> --
> Gary''s Student - gsnu200800
>
>
> "Paul H" wrote:
>
> > Gary and Bob, your solution is counting the "If" statement in the cells. I
> > have 1 name (Text) and 30 blank cells and your formula returns 31?
> >
> >
> > "Gary''s Student" wrote:
> >
> > > If A1 thru A10 contain either text or formulas returning a blank, then:
> > >
> > > =COUNTA(A1:A10)-COUNTBLANK(A1:A10)
> > >
> > > --
> > > Gary''s Student - gsnu200800
> > >
> > >
> > > "Paul H" wrote:
> > >
> > > > I would like to count the text in a column, (each text would count as 1), the
> > > > column contains a simple "If" statement that will return either a name or a
> > > > blank. The text counting solutions I see in these posts also count the If
> > > > statement as 1.

You have solved it!!!

Use:

=IF(B17=0,C18,"")

instead of:

=IF(B17=0,C18," ")


--
Gary''s Student - gsnu200800


"Paul H" wrote:

> Don't know what going on, your suggested formula doesn't work, the "If"
> statements is =IF(B17=0,C18," ") the formula counts this cell even when the
> results are blank, is my If statement causing the problem?
>
>
> "Gary''s Student" wrote:
>
> > The solution the Bob & I proposed will work for a block of cells none of
> > which are truly empty; that is they all will have text showing or have a
> > formula returning a blank.
> >
> > If this is not the case and the block of cells has both cells with visible
> > text and cells that are truly empty, then just use the COUNTA() function.
> > --
> > Gary''s Student - gsnu200800
> >
> >
> > "Paul H" wrote:
> >
> > > Gary and Bob, your solution is counting the "If" statement in the cells. I
> > > have 1 name (Text) and 30 blank cells and your formula returns 31?
> > >
> > >
> > > "Gary''s Student" wrote:
> > >
> > > > If A1 thru A10 contain either text or formulas returning a blank, then:
> > > >
> > > > =COUNTA(A1:A10)-COUNTBLANK(A1:A10)
> > > >
> > > > --
> > > > Gary''s Student - gsnu200800
> > > >
> > > >
> > > > "Paul H" wrote:
> > > >
> > > > > I would like to count the text in a column, (each text would count as 1), the
> > > > > column contains a simple "If" statement that will return either a name or a
> > > > > blank. The text counting solutions I see in these posts also count the If
> > > > > statement as 1.

Yes. Isn't it strange that COUNTBLANK and ISBLANK have different ways of
treating the empty string ""?
--
David Biddulph

"Bob Phillips" <(E-Mail Removed)> wrote in message
news:uWLjK6i$(E-Mail Removed)...
> =COUNTA(M2:M20)-COUNTBLANK(M2:M20)
>
> --
> __________________________________
> HTH
>
> Bob
>
> "Paul H" <(E-Mail Removed)> wrote in message
> news:147A55BA-4B87-48C9-B767-(E-Mail Removed)...
>>I would like to count the text in a column, (each text would count as 1),
>>the
>> column contains a simple "If" statement that will return either a name or
>> a
>> blank. The text counting solutions I see in these posts also count the
>> If
>> statement as 1.
>
>

Thanks Gary.

"Gary''s Student" wrote:

> You have solved it!!!
>
> Use:
>
> =IF(B17=0,C18,"")
>
> instead of:
>
> =IF(B17=0,C18," ")
>
>
> --
> Gary''s Student - gsnu200800
>
>
> "Paul H" wrote:
>
> > Don't know what going on, your suggested formula doesn't work, the "If"
> > statements is =IF(B17=0,C18," ") the formula counts this cell even when the
> > results are blank, is my If statement causing the problem?
> >
> >
> > "Gary''s Student" wrote:
> >
> > > The solution the Bob & I proposed will work for a block of cells none of
> > > which are truly empty; that is they all will have text showing or have a
> > > formula returning a blank.
> > >
> > > If this is not the case and the block of cells has both cells with visible
> > > text and cells that are truly empty, then just use the COUNTA() function.
> > > --
> > > Gary''s Student - gsnu200800
> > >
> > >
> > > "Paul H" wrote:
> > >
> > > > Gary and Bob, your solution is counting the "If" statement in the cells. I
> > > > have 1 name (Text) and 30 blank cells and your formula returns 31?
> > > >
> > > >
> > > > "Gary''s Student" wrote:
> > > >
> > > > > If A1 thru A10 contain either text or formulas returning a blank, then:
> > > > >
> > > > > =COUNTA(A1:A10)-COUNTBLANK(A1:A10)
> > > > >
> > > > > --
> > > > > Gary''s Student - gsnu200800
> > > > >
> > > > >
> > > > > "Paul H" wrote:
> > > > >
> > > > > > I would like to count the text in a column, (each text would count as 1), the
> > > > > > column contains a simple "If" statement that will return either a name or a
> > > > > > blank. The text counting solutions I see in these posts also count the If
> > > > > > statement as 1.