Hi,

I have a formula for counting the number of bins in a column of cells where another criteria applies. There may not always be a bin number in that column, unfortunately this results in an #N/A error.

Can anyone help with a revision to this formula to ignore blank cells?

Example sheet attached.

Thanks in advanceBinCount.xlsx