Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find value in array | Excel Worksheet Functions | |||
figure out why this formula isn't calculating correctly | Excel Discussion (Misc queries) | |||
formula wont copy across to other cells correctly | Excel Discussion (Misc queries) | |||
How to correctly write a cross-sheet "IF" formula in Excel | Excel Worksheet Functions | |||
formula returns (correctly) a negative value | Excel Discussion (Misc queries) |