Count value for formula cells returning a value

[guest123]

I have a column of cells which each contain a formula. If two conditions are met, these cells return a value comprised of two other cells concatinated together.
As this column is some 300 cells large, I am now looking to create a count function to count the number of times something is displayed in the cell, i.e. if the cell remains blank on 200 rows because the conditions in those cells are not met, I want a cell which will return the value '100'.
Any help much appreciated! Thanks!

[Bryan Hessey]

I have a column of cells which each contain a formula. If two conditions are met, these cells return a value comprised of two other cells concatinated together.
As this column is some 300 cells large, I am now looking to create a count function to count the number of times something is displayed in the cell, i.e. if the cell remains blank on 200 rows because the conditions in those cells are not met, I want a cell which will return the value '100'.
Any help much appreciated! Thanks!

Hi

=CountBlank(A1:A100)

will count those cells which have a formula and a blank result.


=CountA(A1:A100)-CountBlank(A1:A100)

should help you.

hth
---

[guest123]

That worked, fantastic - thanks very much!

[Bryan Hessey]

That worked, fantastic - thanks very much!

good to see, and thanks for the response.
---