Making A Subtotal Ignore A Value In A Cell Wi

DocumentID: 607364
Revision Date: 29-Feb-96 1:32:27 PM

The information in this document applies to:
WordPerfect® 5.1 for DOS

Problem

Solutions: When using a math formula and a + (subtotal) in the same column of a table, it will add the figure generated by the formula in the subtotal. In order to get the subtotal to ignore the value in the formula and the numbers above the formula, follow these steps: 1. Create a blank cell below the cell with the formula. 2. Make this cell a text cell and then enter a + (subtotal), using math and + (subtotal), in the cell. The + (subtotal) entered in the text cell is recognized by the + (subtotal) below it. Because it was in a text cell, it did not add the figures in the cells above the first + (subtotal), it only added between the two + (subtotal) codes.

Answer:

Details:

Product specifications, packaging, technical support and information (*Specifications*) refer to theUnited States retail English version only. Specifications for other versions may vary. All Specifications, claims, features, representations, and/or comparisons provided are correct to the best of our knowledge of the date of publication, but are subject to change without notice.OUR MAXIMUM AGGREGATE LIABILITY TO YOU AND THAT OF OUR DEALERS AND SUPPLIERS IS LIMITED. IT SHALL NOTEXCEED THE AMOUNT YOU PAID TO ACCESS THE INFORMATION. SEE LEGAL DISCLAIMER.