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
I was wondering if anyone could help me with a formula for some work I am currently doing. I have a set of data (numbers ranging from -0.8 to + 0.7) which are in cells H10:H46. I want to have a formula which calculates the percentage of these cells which contain numbers which are either greater than and including +0.4 and lesser than and including -0.4. the percentage needs to include both of these.

many thanks
Related:

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
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
0