Hi

If the only value in your columns are 1's then try:
=COUNTIF(AJ3:AJ410,1)

or

SUM(INT(AJ3:AJ41)) enter using CTRL+SHIFT+ENTER which will count 1's that
are text and not actual numbers.

if neither works then check to make sure your calculation is set to automatic.

HTH
Jean-Guy

"ulupi" wrote:

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.