It appears that your "numbers" are really text. Changing the format of a
text number cell to Number does not effect that a "number" is really text.
You must format the cell before entering the number.
Given that you have already entered the numbers, do this. In some empty
cell, enter a 1. Then copy that cell. Now select all the cells in which
you have your non-number numbers. Then click on Edit - Pastespecial and
select Multiply, then OK. That forces any entry that looks like a number to
a number. HTH Otto
"ulupi" wrote in message
...
Column AJ has cells that either contain "1" or are blank but the folrmula
returns a value of "0".

All cells including the cell containing the formula are formatted for
Numbers.