hi
there is no row limit to a simple sum formla that i am aware of.
use this formula
=sum(A1:A1000) and =sum(B1:B1000)
place the fomula any where you want. adjust the ranges to suit.

Regards
FSt1

"pitydafool" wrote:

I want to total columns on a sheet.
I have the following sheet: (a1,a2 etc line numbers, 2 columns A & B)

__A__ __B____
a1 GASOLINE
a2 gals cost
a3 13.01 45.01
a4 ? 38.00
a5 20.00 75.00
etc,etc
a106 25.00 85.00

I need to add total gals column (A) and then total cost column (B).
I cannot figure out how to do that. I believe I read in a thread that I
can't add more than 30 lines? I have Excel 2003.



--
fool