Count function to count ONLY formula results

[Churchy LaFemme]

I have 25 columns and several hundred rows. The 25 columns are all lookup values (or nothing is displayed because of ISNA or &"" formula tricks). I want a final column to make sure there is at least one value in every row. However, the counta and other formulas I have tried count the formulas as values.

Help!

By the way, all the values are TEXT. (They are formatted as general, but are not numbers.)

I have tried using wildcards and greater than .5 as criteria and about to just give up and go have a drink.

 

[AlphaFrog]

Try something like this (fill in the missing cell references)...

=LEN(A1&B1&C1&[COLOR="Red"]....[/COLOR] X1&Y1)>0

 

[andiemac]

Or how about =COUNTA(A1:Z1)-COUNTIF(A1:Z1,"")

 

[Churchy LaFemme]

Yee haw! The counta minus counta formula worked!

The left formula gave me a TRUE result, even for my test row which I know has no results.

Thanks! I can leave work with a project finished.

 

[T. Valko]

I have 25 columns and several hundred rows. The 25 columns are all lookup values (or nothing is displayed because of ISNA or &"" formula tricks). I want a final column to make sure there is at least one value in every row. However, the counta and other formulas I have tried count the formulas as values.

Help!

By the way, all the values are TEXT. (They are formatted as general, but are not numbers.)

I have tried using wildcards and greater than .5 as criteria and about to just give up and go have a drink.

Try this...

=COUNTIF(A2:J2,"?*")

That will count cells that contain text and will exclude cells that contain formula blanks.

 

[Churchy LaFemme]

Try this...

=COUNTIF(A2:J2,"?*")

That will count cells that contain text and will exclude cells that contain formula blanks.

For some reason, the first solution stopped working (this was on an existing spreadsheet) but the second solution saved the day.

Thank you.

 

[T. Valko]

For some reason, the first solution stopped working (this was on an existing spreadsheet) but the second solution saved the day.

Thank you.

Good deal. Thanks for the feedback!