How to find a number <1050 and work out a percentage on numbers

I have 17 drivers on my team, and they get a score each week, I need to work out the percentage of drivers who score <1050. how could I use an IF statement to work out the percentage of drivers who score <1050?

MacBook Air, macOS 14.0

Posted on Oct 17, 2023 11:58 PM

Reply
2 replies

Oct 18, 2023 2:52 AM in response to Ryan_G_95

Hi Ryan,

I would use COUNTIF for this task.

Row 19 is a Footer, therefore I can select the complete column as input.

Formula for cell B19= COUNTIF(B,"<1050")÷17

It will count every entry that is < 1050 and divide this result by 17.

COUNTIF - Apple Support


Optional you can do it like this, then it will count all row that have an entry (>1).

Maybe one of your drivers is on vacation and should not be counted in this week.


Based on your region the , or the ; will be used to separate the different sections of a formula. If you write one thousand as 1,000.00 then the , is used as your formula separator. If you write one thousand as 1.000,00 then the ; is used as your formula separator.


Hope this will solve your question, please let me know if this worked for you or if something in unclear.


Regards Ralf


How to find a number <1050 and work out a percentage on numbers

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.