Excel doesn't calculate totals correctly

[Joe]

The following formula returns the incorrect totals:

=sum(entry!i:i)+(entry!j:j)

it will calculate the total of column j from sheet entry
but not from column i on the same sheet.

 

[Aladin Akyurek]

=SUM(entry!I:J)

 

[Andy Brown]

=SUM(Entry!I:I)+SUM(Entry!J:J)

Or just =SUM(Entry!I:J)

HTH,
Andy

 

[Gord Dibben]

Joe

Change to =sum(entry!i:i)+sum(entry!j:j)

Shorter would be =SUM(entry!J:K)

Gord Dibben XL2002

 

[Gord Dibben]

Shorter would be =SUM(entry!J:K)

And correct would be =SUM(entry!I:J)

Gord