| View previous topic :: View next topic |
| Author |
Message |
stuartp77
General User
Joined: 28 Jul 2004
Posts: 35
Location: Melbourne, Australia
|
 Posted: Sun Sep 05, 2004 5:01 am Post subject: Margin appeared for no reason |
 |
|
Can someone please tell me how to add a column of figures in which there are some blank spaces. I tried but was only successful in adding together the cells down to the blank one. The ones with figures in below the blank one were ignored.
Stuartp77
_________________
Stuartp77 |
|
| Back to top |
|
 |
David
Super User
Joined: 24 Oct 2003
Posts: 5668
Location: Canada
|
| Posted: Sun Sep 05, 2004 1:06 pm Post subject: Re: Margin appeared for no reason |
|
|
| stuartp77 wrote: | Can someone please tell me how to add a column of figures in which there are some blank spaces. I tried but was only successful in adding together the cells down to the blank one. The ones with figures in below the blank one were ignored.
Stuartp77 |
Type in the formula; don't rely on the Sigma summation icon to do the work. If you have data in cells from A1 to A10, with some missing, still type =SUM(A1:A10) for your formula.
David. |
|
| Back to top |
|
|
stuartp77
General User
Joined: 28 Jul 2004
Posts: 35
Location: Melbourne, Australia
|
| Posted: Mon Sep 06, 2004 4:42 am Post subject: Adding column of figures with blank cells |
|
|
Thank you David for your help.
That little piece of information re adding column of figures including blank cells has helped my tremendously.
Much obliged to you. (You probably noticed I had the wrong heading).
Best regards,
Stuart.
_________________
Stuartp77 |
|
| Back to top |
|
|
|
