CountIF

[OceanBlue]

I have attached the Excel file

I would like to find out how to use the COUNTIF condition with another formula.

The countif is in cell A3, reading from A5:A200, and in A5 and on, I have the formula of
=MAX(A4:A$4)+1, that will create custom counter Arc-1, Arc-2, Arc-3.................

My cell A3 formula is =COUNTIF(A5:A10, ">=Arc-1")
But returns Zero .

Not too sure how can I get it to work !

[NBVC]

If you have formula: =MAX(A4:A$4)+1 generating something like Arc-1, then probably you have the cell custom formatted as "Arc-"general or similar.

so then you should only need:

=COUNTIF(A5:A10, ">=1")

[Miraun]

Nope, no attached file...

And from the description you gave, Arc-1 is not less than Arc-2, they are both considered strings of text, that'd be like asking excel to know that Miraun => Oceanblue.

... NBVC >= Miraun

[OceanBlue]

If you have formula: =MAX(A4:A$4)+1 generating something like Arc-1, then probably you have the cell custom formatted as "Arc-"general or similar.
so then you should only need:
=COUNTIF(A5:A10, ">=1")

YEP, that did it.

Thanks

[Oceans]

Thanks..................................