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?
[SOLVED] Results of CountIf as Ratios or Percentages
[SOLVED] Results of CountIf as Ratios or Percentages
Last edited by bluhawk19 on Sat Nov 24, 2018 11:30 pm, edited 1 time in total.
Re: Results of CountIf as Ratios or Percentages
Code: Select all
=COUNTIF(G2:G26; ">=6.6")/COUNT(G2:G26)
Code: Select all
=COUNTIF(G2:G26; ">=" & 66/10)/COUNT(G2:G26)
On Windows 10: LibreOffice 24.2 (new numbering) and older versions, PortableOpenOffice 4.1.7 and older, StarOffice 5.2
---
Lupp from München
---
Lupp from München