I need a formula for.......

R

Roger Govier

Hi

=SUM(A1:A10)
where A1 is the first cell in column A that you want included and A10 is the
last cell.
Change reference to suit.
You can also use
=SUM(A:A)
to include all cells within column A, but be sure not to have your cell with
the formula in column A or else you will get a circular reference
 

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

Copy addition formula of non-consecutive horizontal cells 2
Autonumber field in Excel that behaves the same as Access 0
Delete a formula but leave the data. 2
formula for arriving net difference 0
Construct table from selected rows 4
if then formula 4
Newbie Help - IF Yes No Function 0
Display weeks from a Milestone 0

Top