If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Formula to add
I want to be able to add a column of figures, but in several cells they will
be blanc. I have found that the autosum only works if there are numbers in each cell. In this particular document I have subtotals in the right hand column that I want to total at the end with probably 4 or 5 blanc cells in between each sub total. To put a formula saying D1+D8+D20 etc and having to count down to know the cells to put in the formula, you may as well use a calculator. Is there any formula you can put that would add all above without having to put a zero in the blanc cells. Could anyone help please. Margaret |
#2
|
|||
|
|||
Formula to add
Bonjour,
Dans son message, Margaret Upton écrivait : In this message, Margaret Upton wrote: || I want to be able to add a column of figures, but in several cells they will || be blanc. I have found that the autosum only works if there are numbers in || each cell. In this particular document I have subtotals in the right hand || column that I want to total at the end with probably 4 or 5 blanc cells in || between each sub total. To put a formula saying D1+D8+D20 etc and having to || count down to know the cells to put in the formula, you may as well use a || calculator. Is there any formula you can put that would add all above || without having to put a zero in the blanc cells. Could anyone help please. || You could try giving your sub-totals bookmark names (Insert Bookmark). Then use those names in the formula: =(Sub1 + Sub2 = Sub3) etc. or =SUM(Sub1, Sub2, Sub3) -- Salut! _______________________________________ Jean-Guy Marcil - Word MVP ISTOO Word MVP site: http://www.word.mvps.org |
#3
|
|||
|
|||
Formula to add
Hi Margaret,
Assuming you know how many rows there are to sum, you could use a formula like: =SUM(D120) which won't be affected by blank cells. To do this, select the 'total' cell in column D, press Shift-F9 to create a pair of field braces and type the formula between them. Then press F9 to update the field. For more information on Word field maths, see: http://www.wopr.com/cgi-bin/w3t/show...&Number=365442 Cheers "Margaret Upton" wrote in message ... I want to be able to add a column of figures, but in several cells they will be blanc. I have found that the autosum only works if there are numbers in each cell. In this particular document I have subtotals in the right hand column that I want to total at the end with probably 4 or 5 blanc cells in between each sub total. To put a formula saying D1+D8+D20 etc and having to count down to know the cells to put in the formula, you may as well use a calculator. Is there any formula you can put that would add all above without having to put a zero in the blanc cells. Could anyone help please. Margaret --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.684 / Virus Database: 446 - Release Date: 13/05/2004 |
#4
|
|||
|
|||
Formula to add
Jean
Thank you very much will try that. Margaret "Jean-Guy Marcil" wrote in message ... Bonjour, Dans son message, Margaret Upton écrivait : In this message, Margaret Upton wrote: || I want to be able to add a column of figures, but in several cells they will || be blanc. I have found that the autosum only works if there are numbers in || each cell. In this particular document I have subtotals in the right hand || column that I want to total at the end with probably 4 or 5 blanc cells in || between each sub total. To put a formula saying D1+D8+D20 etc and having to || count down to know the cells to put in the formula, you may as well use a || calculator. Is there any formula you can put that would add all above || without having to put a zero in the blanc cells. Could anyone help please. || You could try giving your sub-totals bookmark names (Insert Bookmark). Then use those names in the formula: =(Sub1 + Sub2 = Sub3) etc. or =SUM(Sub1, Sub2, Sub3) -- Salut! _______________________________________ Jean-Guy Marcil - Word MVP ISTOO Word MVP site: http://www.word.mvps.org |
#5
|
|||
|
|||
Formula to add
Thanks very much that works very well, I am very grateful.
Margaret "macropod" wrote in message ... Hi Margaret, Assuming you know how many rows there are to sum, you could use a formula like: =SUM(D120) which won't be affected by blank cells. To do this, select the 'total' cell in column D, press Shift-F9 to create a pair of field braces and type the formula between them. Then press F9 to update the field. For more information on Word field maths, see: http://www.wopr.com/cgi-bin/w3t/show...&Number=365442 Cheers "Margaret Upton" wrote in message ... I want to be able to add a column of figures, but in several cells they will be blanc. I have found that the autosum only works if there are numbers in each cell. In this particular document I have subtotals in the right hand column that I want to total at the end with probably 4 or 5 blanc cells in between each sub total. To put a formula saying D1+D8+D20 etc and having to count down to know the cells to put in the formula, you may as well use a calculator. Is there any formula you can put that would add all above without having to put a zero in the blanc cells. Could anyone help please. Margaret --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.684 / Virus Database: 446 - Release Date: 13/05/2004 |
Thread Tools | |
Display Modes | |
|
|