#DIV0 error

[Matt_Straya]

Hi,
I have a problem and I guess the solution is staring me right in the face.

In column E I have a list of numbers representing days. In column H I have a countif formula that needs to be divided by the corresponding cell value in coluimn E.

"=COUNTIF($H$7:$H$143,1)/E147"
I then format this to give me a percentage. However, I cant get rid of the #DIV0 error and Id just like it to be 0%.

I have attached a copy of what I am trying to do - cells high-lighted in yellow.

If someone could point me in the right direction Id be grateful!
Cheers

 

[bosco_yip]

Try,

In H147, formula copy across and down :

=IF($E147,COUNTIF(H$7:H$143,$D147)/$E147,"")

or (if you like error return 0),

=IF($E147,COUNTIF(H$7:H$143,$D147)/$E147,0)

Regards

 

[Matt_Straya]

PERFECT! Thank you!