Why does this formula =SUM(AJ3:AJ410) not add up/total correctly?
 

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.

Why does this formula =SUM(AJ3:AJ410) not add up/total correctly?
 

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.

Why does this formula =SUM(AJ3:AJ410) not add up/total correctly?
 

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.