Frequency formula help

[Tesnobay]

Hi,

I am trying to use =frequency to count donors to a fund each year. I am having trouble with the lower range donors up to $25. The spreadsheet has 0.00 for folks that didn't donate, and the formula is counting the zero values as part of the lower range, instead of say 1-25, it is counting 0-25.

I am currently using an array that sums between the ranges I want, but I thought FREQUENCY would have been easier to use.

Any suggestions?

 

[Andrew Poulsom]

Can't you make the lowest value in the bins_array zero?

 

[Tesnobay]

Can't you make the lowest value in the bins_array zero?

I suppose I could, but I am not interested in counting zero's in this scenario.

I suppose I could then hide that row, but that's not what I am trying to determine.