Excel Formula Help

[Brian]

I'm trying to create a formula to add a column of numbers.

I can easily figure out what to do when it is a static number (i.e.
=SUM(C3:C8) )

What I am having trouble with is when the number of entries varies. Is
there a way to create a formula so it will "sense" how many numbers there are
without my having to manually manipulate the formula everytime?

Thank you.

 

[Mike H]

Open a new spreadsheet in Excel and try this.. enter the numeral '1' into
the A column using cells A1 through A4.. go to cell B1 and enter
=SUM(A1:A20).. this will return a value of 4.. now enter the numeral '1'
into cells A5 through A20.. you will see the totals cell does indeed auto
sense..

You can specify a range of cells without having to have entered
information..

Hope this helps

 

[Brian]

Mike,

Thanks for the reply. That did the trick!

Brian

 

[Mike H]

You're welcome..

Mike,

Thanks for the reply. That did the trick!

Brian