Using Formulas for Calculations in Spreadsheet Blocks
Learn how to use formulas like sum, average, multiplication, and more in QuoteCloud Spreadsheet Blocks to automate calculations.
Apply formulas in your Spreadsheet Block to quickly calculate totals, averages, percentages, and other values without manual entry.
Using Basic Formulas (SUM, AVERAGE, MIN, MAX)
Learn how to use basic formulas to perform quick calculations inside your Spreadsheet block.
Understand how to apply SUM, AVERAGE, MIN, and MAX functions to your data sets.
Steps to use basic formulas
7 steps
Select the cell for the SUM formula
Click the cell where you want the total sum to appear (e.g., cell D6).
Enter the SUM formula
Type =sum( and then select the range of cells you want to add together (e.g., D2:D4). Press enter to display the total calculation. You don't need to type the closing bracket, as the sheet adds it for you.
Select the cell for the MIN formula
Click the cell where you want to find the lowest value in a range (e.g., cell D7).
Enter the MIN formula
Type =min( followed by the range of cells (e.g., D2:D4), then press enter.
Select the cell for the AVERAGE formula
Click the cell where you want the average value to be calculated (e.g., cell D8).
Enter the AVERAGE formula
Type =average( and select your range (e.g., D2:D4), then press enter.
Enter the MAX formula
To find the highest value, select your target cell and type =max( followed by the range. Press enter to complete the calculation.
Picking cells with the keyboard
After typing an operator or an opening bracket, such as =sum(, press an arrow key to point at a cell. Hold Shift while pressing an arrow key to stretch the reference into a range. Keep typing to carry on with the formula.
When you're not pointing at a cell, an arrow key saves the cell and moves to the next one. To move within your text instead, click into it first.
Help while you type
Function suggestions: Start typing a function name to see matching functions and what each one does. Press Enter or Tab to use the highlighted one.
Function hints: Inside the brackets, a hint shows the function's arguments and explains the one you're on. Arguments in square brackets are optional. If the hint is in your way, select the × or press F1 to hide it. Select the ? or press F1 again to bring it back. The sheet remembers your choice in this browser. The hint also hides while you press a cell to point at it.
Coloured references: Each cell reference in your formula has the same colour as the outline on the sheet. This includes whole columns and rows, like
A:Aor2:3, which also move when you insert or delete columns and rows.Matching brackets: When your caret is next to a bracket, it and its partner are highlighted.

Locking a reference with F4
Put your caret on a cell reference and press F4 to add dollar signs, which stop that part of the reference changing when you copy the formula. Each press moves to the next option: A1, $A$1, A$1, then $A1. On some keyboards, you need to hold fn as well.
Saving from the formula bar
Press Enter in the formula bar to save the cell and move down, or Shift+Enter to move up. Tab moves right, and Esc discards your change.
FAQs
Do formulas update automatically if data changes?
Yes. When you edit values in a QuoteCloud Spreadsheet Block, formulas such as SUM, AVERAGE, MIN, and MAX automatically recalculate so totals, averages, and other computed fields stay current without manual re-entry. This live recalculation keeps quotes and proposals accurate as line items change and is especially useful when you use QuoteCloud as sales quoting software or sales proposal software.
How do I apply a formula in a Spreadsheet Block?
Select the cell where you want the result, then type the function directly into the formula bar or choose a built-in function and select the range. For example: =SUM(A2:A10). You can also use basic arithmetic operators (+, -, *, /) inside the formula bar to build custom calculations for line-item totals and summary fields used in quote software and proposal software templates.
What formulas can I use for quick calculations?
QuoteCloud supports common quick-calculation functions like SUM (add a range), AVERAGE (mean), MIN (smallest value), MAX (largest value), plus basic arithmetic (addition, subtraction, multiplication, division). These are typically enough to calculate totals, averages, minimum/maximum values and simple statistics directly in a Spreadsheet Block for use in sales quoting and proposal documents.
Can I use formulas to calculate percentages and averages?
Yes. Use AVERAGE(range) to compute the mean of a set of values and a simple expression to calculate percentages, for example: =(Part/Total)*100. Combine SUM and AVERAGE to create summary rows and percentage share calculations inside your quote or proposal so clients see accurate breakdowns and totals automatically.
Why is my formula not working or returning errors?
A cell with an error has a small red triangle in its corner. Hover over the cell to see what went wrong. Where the sheet can work out the cause, it names it, such as the empty cell you're dividing by, the cell the error came from, or a function with the wrong number of arguments. Formulas only operate on numeric values. If any referenced cell contains text, stray characters (for example a currency symbol typed as plain text), or a blank text field, the formula can return an error or an unexpected result. Troubleshooting steps: check each referenced cell for non-numeric characters, convert text-formatted numbers to numeric format, remove stray symbols, and replace truly blank text fields with 0 or a valid number.
How can I prevent currency and formatting from breaking formulas?
Avoid typing currency symbols or other characters directly into cells as plain text. Instead, use numeric cell formatting for currency so values remain numeric while displaying the correct symbol. If you must import data, run a quick check to convert any text-formatted numbers to numeric values and remove stray characters before relying on calculations in your quote software or proposal software templates.
How do formulas help automate sales quotes and proposals?
Formulas let you automate totals, taxes, discounts, averages and summary fields so pricing updates in real time as you change quantities or unit prices. That reduces manual errors and speeds up document creation when using QuoteCloud as quote software or proposal software, letting teams generate accurate, professional sales documents faster.
What are best practices for maintaining accurate calculated fields in Spreadsheet Blocks?
Use consistent numeric formatting, keep formula cells separate from editable input cells, and replace blank text fields with 0 when a numeric value is expected. Test formulas on a small sample before using them in live quotes, and prefer built-in functions like SUM and AVERAGE for clarity. These practices reduce errors and make your sales quoting software or proposal software templates more reliable.
More in Spreadsheets - Entering & Managing Data
- Adding Rows and Columns to a Spreadsheet BlockLearn how to add rows and columns to a Spreadsheet Block in QuoteCloud to expand and organise your data effectively.
- Deleting Rows and Columns from a Spreadsheet BlockFind out how to delete rows and columns from a Spreadsheet Block in QuoteCloud to clean up and simplify your data.
- Entering and Managing Data in the Spreadsheet BlockLearn how to enter, edit, and clear data in the Spreadsheet Block. This guide covers typing values, editing cells using the Formula Bar or directly in the cell, double-click editing, and clearing single or multiple cell contents. Perfect for managing data quickly and accurately i