Displaying result in parentheses
 

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!

Displaying result in parentheses
 

Use concatenation:

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

"Stilla" wrote:

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!

Displaying result in parentheses
 

Format as (0)

--

HTH

Bob Phillips

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

"Stilla" wrote in message
...
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!

Displaying result in parentheses
 

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

Stilla wrote:
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!

Displaying result in parentheses
 

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

(just a warning)

Stilla wrote:

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!

--

Dave Peterson