Displaying result in parentheses

S

Stilla

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!
 
B

Bob Phillips

Format as (0)

--

HTH

Bob Phillips

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

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).
 
Top