-3

I have a date column and a column that states "Include" or "Don't Include." I want to calculate the Percentile of each row in my data set given that they are marked to be included. Any thoughts on how to group them?

Adrian Mole
  • 49,934
  • 160
  • 51
  • 83
RCarmody
  • 712
  • 1
  • 12
  • 29
  • 5
    Welcome to the site. Please share some sample data (you can use dummy values if it's private) and give us a sense of what you've tried. – Josh Friedlander Dec 16 '18 at 16:14

1 Answers1

1

@RCarmody try:

=IF(B2="Included",COUNTIF($B$2:$B$11,"Included")/COUNTA($B$2:$B$11),"")

Output: enter image description here

Error 1004
  • 7,877
  • 3
  • 23
  • 46