Auto Sum logic

Hi All,

What's a logic used for auto sum ?
Since some time i got horizontal summation another time i got vertical .
If the above cell is merged then i got only the horizontal sum.
Sometimes it include the char field also.

Where will i study the logic behind it.
Sent some related links to refer..

Regards,
Sasi.

Originally Posted by sasi

Hi All,

What's a logic used for auto sum ?
Since some time i got horizontal summation another time i got vertical .
If the above cell is merged then i got only the horizontal sum.
Sometimes it include the char field also.

Where will i study the logic behind it.
Sent some related links to refer..

Regards,
Sasi.

The rules appear to be

1. AutoSum works with numbers, and the numbers must be in adjacent cells. The definition of adjacent in this context appears to be cells above or cells to the left.

2. If there are a mixture of numbers and text above or to the left, AutoSum ignores any text and uses the numbers as far as the cell immediately before the first text value.

3. If any of the cells are merged, if the Autosum is on the first row of a merged range, it expands the range summed to include the rows contained by the merge. If the AutoSum is on any other row of a merged range, the autosum obeys the same rules as in 2 above.

HTH

Thx HTH,

Shall i refer any links to get a brief content ? or Notes.

Regards,
Sasi.

Originally Posted by sasi

Thx HTH,

Shall i refer any links to get a brief content ? or Notes.

Regards,
Sasi.

Sorry, I'm not aware of any particular links.
You could try googling around.

What I posted was just my observation about the way AutoSum works - and something I should have caveated before, it's how it works on a Mac using Excel for Mac 2004. Though I've no reason to believe it's any different in the Windows version.

HTH,

Thx
I will search it..

Regards,
Sasi.

Hi,

I selected some range , now i press summation button (Sigma). It doesn't work .It include some merged cells.this is bug or exceed the auto sum criteria. It has any criteria then sent me..

Regards,
Sasi.

Originally Posted by sasi

Hi,

I selected some range , now i press summation button (Sigma). It doesn't work .It include some merged cells.this is bug or exceed the auto sum criteria. It has any criteria then sent me..

Regards,
Sasi.

What do you mean it doesn't work. Do you simply mean it's giving you a result but not one which you expect or even accept?

Does it give you a result according to the rule number 3 I spelled out a few posts ago?

Please post a full description of the range you're trying to autosum, preferably by attaching the workbook here and I'll take a look.

Rgds

Do the Scenario :

• Enter the data in row basis (C4:C10)
• Merge to the last two cells (C9:C10)
• Select the Cell range (C4:C10)
• Now use the Summation

Understand .. & try it.
What is "rule number 3" ?

Regards,
Sasi

Originally Posted by sasi

Do the Scenario :

• Enter the data in row basis (C4:C10)
• Merge to the last two cells (C9:C10)
• Select the Cell range (C4:C10)
• Now use the Summation

Understand .. & try it.
What is "rule number 3" ?

Regards,
Sasi

Yes, I fully understand it thanks.
What's the point you're trying to make? It works exactly as I expect it too.

Are you perhaps misunderstanding the situation when you merge two cells each containing a value? If you do that then you have to lose one of the values.

In any merge of a range of cells, it's only the top left hand cell value that is retained - XL does warn about this.

My rule 3 is still contained in my original post. Have you read it?
Rgds