Change formula to show %

Sheila Poland

I used this formula to get my % in my Sheet Summary:

=COUNTIF([Employment Status at Enrollment]:[Employment Status at Enrollment], ="Manufacturer") / COUNT([Employment Status at Enrollment]:[Employment Status at Enrollment])

I would like it to show up as 40% (round up).

Any assistance would be appreciated. Thank you!

Kimberly Loveless

Hi Shelia,

In the Data Sheet you should be able to select percentage format. You may need to also edit the decimal places as well. The buttons to do both are on the right side of that top tool bar on the sheet (I am showing that part of the tool bar)

Hope that helps

Paul Newcome

While you are counting on text based criteria, your formula is outputting a number. Since it is outputting a number, you should be able to format the sheet summary field as a percentage using the option in the top toolbar.

Kimberly Loveless

Hi Shelia,

In the Data Sheet you should be able to select percentage format. You may need to also edit the decimal places as well. The buttons to do both are on the right side of that top tool bar on the sheet (I am showing that part of the tool bar)

Hope that helps

Sheila Poland

Hi Kimberly,

Thank you for replying. The issue I am running into is that the columns I am "counting" are not numerical columns - I am counting based on a select word - in this case "Manufacturer". I can select the % for these columns but it doesn't do anything since they are not numerical.

I thought I would have to do this as a part of my formula - but I could be totally wrong :)

Paul Newcome

While you are counting on text based criteria, your formula is outputting a number. Since it is outputting a number, you should be able to format the sheet summary field as a percentage using the option in the top toolbar.

Sheila Poland

WOW - that was easy - I see what Kimberly was trying to tell me now. Duh!

Thank you for assisting!

Paul Newcome

Happy to help. 👍️