View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Paul Mathews
 
Posts: n/a
Default 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!