[SOLVED] Results of CountIf as Ratios or Percentages

Discuss the spreadsheet application
Post Reply
bluhawk19

[SOLVED] Results of CountIf as Ratios or Percentages

Post by bluhawk19 »

Hi,

I'm having trouble with finding a way to display formula results the way that I want them displayed.

I'm using this formula in my spreadsheet: =COUNTIF(G2:G26; ">=6.6")

I want to display the results as a ratio or a percentage that tells me how much of the range is over 6.6. So, instead of 23, I want it to either tell me 23/25 or 92%. Is this possible?
Last edited by bluhawk19 on Sat Nov 24, 2018 11:30 pm, edited 1 time in total.
User avatar
Lupp
Volunteer
Posts: 3542
Joined: Sat May 31, 2014 7:05 pm
Location: München, Germany

Re: Results of CountIf as Ratios or Percentages

Post by Lupp »

Code: Select all

=COUNTIF(G2:G26; ">=6.6")/COUNT(G2:G26)
To get it also work in a "comma-locale" use

Code: Select all

=COUNTIF(G2:G26; ">=" & 66/10)/COUNT(G2:G26)
To get the result shown in a percentage format or a fraction format, go to the 'Numbers' tab after clicking 'Format Cells...' in the context menu of the respective cell, and choose the wanted format there.
On Windows 10: LibreOffice 24.2 (new numbering) and older versions, PortableOpenOffice 4.1.7 and older, StarOffice 5.2
---
Lupp from München
Post Reply