frequency formula

I am trying to make a histogram and I used =FREQUENCY(B1:B200;D9:D19) to get the frequency but it seems that there is something wrong with my formula because

1. for the 108.25-11.28 it shows more than 100 and i only have 100 data (should exclude zeros)
2. I double check the data by making it in ascending order and it does not match

Your current FREQUENCY formula is the equivalent of

=SUMPRODUCT(--($B$1:$B$200<=D9))

giving you results less than the lower limit (and including zeroes)

If this is what you require (and exclude zeroes) use
=SUMPRODUCT(($B$1:$B$200<=D9)*($B$1:$B$200<>0))

In case you require number of units between the upper and lower limits use (this will automatically exclude zeroes)
=SUMPRODUCT(($B$1:$B$200>=D9)*($B$1:$B$200<=F9))