simple addition

P

pitydafool

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.
 
M

michaelberrier

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.

If I understand your question, all you need is =SUM(B:B) in your
destination cells. There shouldn't be a limit to how much data you
can put in each one.
 
F

FSt1

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
 
E

Elkar

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
 
P

pitydafool

Thanks to all, appreciate it much!
--
fool


Elkar said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Search cell value in same column 3
Copy a formula using Vlookup 2
Balance Sheet Formula 5
Average Question 2
Calculate end date and time 1
Dynamic pointing to a cell 0
Formula Question 2
sum of timesheet 1

Top