Displaying result in parentheses

[Guest]

Thanks in advance for any help with this...

How do I display the result of a "countif" formula in parentheses? What
would I add to the following formula:

=countif(a:1:a100,"Blue")

so that the result is (35) instead of 35 ?

Thanks!

 

[Guest]

Use concatenation:

="("&countif(a:1:a100,"Blue")&")"

 

[Bob Phillips]

Format as (0)

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

 

[Mark Lincoln]

Use a custom number format of:

(0)

Note, though, that many people will interpret this as a negative
number. If the number *is* negative it will display as -(35).

 

[Dave Peterson]

A lot of people will read (35) as negative 35.

(just a warning)