Thanks to all, appreciate it much!
--
fool


"Elkar" wrote:

There's really no limit to the number of lines you can total. Just use the
SUM function. Type this formula into the cell where you want your total to
appear:

=SUM(A1:A106)

Repeat for your next total:

=SUM(B1:B106)

The : indicates a range starting at the cell reference on the left and
ending at the cell reference on the right. So everything from cell A1
through cell A106 will be added together.

HTH
Elkar


"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