Calculate Across Table

This page allows you to create a table that will add or subtract rows of two numbers horizontally then add all columns vertically.  It is typically used for matching grants but can be used for any data for which you want to do simple calculations.

  • The label column allows for your own labels or can be left as a freeform so that your applicants can enter the label.
  • Columns 1 and 2 will allow your applicants to enter numerical data according to the column headers and row labels; you can designate whether these columns are added or subtracted from one another.
  • The final column will automatically calculate columns 1 and 2 according to your settings. All columns will automatically total.
Add a custom title that will appear to your applicants in the application table of contents.
Add custom headers to the two columns being calculated.
Create custom labels to request specific numerical data from applicants.
Leave rows as freeform and allow applicants to enter their own labels.
Designate whether columns 1 and 2 should be added or subtracted.
All sections automatically subtotal.
All subtotals automatically total at the bottom of the table.