Formula which calculates the percentage of these cells
Closed
Lucy

Mar 17, 2015 at 10:59 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022  Mar 23, 2015 at 12:54 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022  Mar 23, 2015 at 12:54 PM
Related:
 Formula which calculates the percentage of these cells
 Excel marksheet percentage formula  Guide
 Logitech formula vibration feedback wheel driver  Download  Drivers
 Vat calculation formula  Guide
 Date formula in excel dd/mm/yyyy  Guide
 Number to words in excel formula  Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Mar 23, 2015 at 12:54 PM
Mar 23, 2015 at 12:54 PM
Hi Lucy,
Try this formula:
=(COUNTIF(H10:H46,"<=0,4")+COUNTIF(H10:H46,">=0,4"))/16
Don't forget to format your formula cell as Percentage to get the desired result.
Best regards,
Trowa
Try this formula:
=(COUNTIF(H10:H46,"<=0,4")+COUNTIF(H10:H46,">=0,4"))/16
Don't forget to format your formula cell as Percentage to get the desired result.
Best regards,
Trowa