"Gord Dibben" wrote:

Try setting calculation mode to Automatic.

ToolsOptionsCalculation.


Gord Dibben MS Excel MVP

On Mon, 5 Jan 2009 14:57:00 -0800, franky
wrote:

It shows the first formula answer all belows which are not correct.

But the formula itself is correct.

Example

=SUM(D19:G19) =1125
=SUM(D20:G20) =1125 x
=SUM(D21:G21) =1125 x
=SUM(D22:G22) =1125 x




Thank you very much. I get it.

Have a nice day !!!

Franky