Sum a series of rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi; I hope this is an easy one. In Word 2007 is it possible to sum the
contents of several rows of data with some rows being blank; then have that
sum multiplied by .05 and then the two values added together?

(it's a simple quote where I need a subtotal and have it muliplied by the
sales tax % and then a total).

In earlier versions I thought you couldn't have any blank rows.

Thanks, Lloyd
 
Hi Lloyd,

You can use a formula field for this.

For example a formula field coded as:
{=SUM(A1:A10)*0.05}
would give you the amount of sales tax for cells A1:A10, while
{=SUM(A1:A10)*1.05}
would give you the total including sales tax for the same cells.

Note: the field braces are created in pairs via Ctrl-F9 - you can't simply type them in.

For more information, on this and a wide range of other calculations in Word, check out my Word Field Maths 'tutorial', at:
http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=365442

Cheers
 
Back
Top