Perform dynamic calculations in tables with SUMIF and SUMPRODUCT IF formulas

We are constantly expanding Zoho Writer's formula library to meet the growing demand to perform dynamic calculations within documents. Following our recent additions, DATEDIF, NPV, PV, and FV, we are excited to introduce two powerful new formulas: SUMIF and SUMPRODUCT IF.

These formulas allow you to dynamically calculate and display the sum of a table's cell values in a document based on specific conditions. Whether you're working on a standard document, merge, or fillable template, you can add these functions to automate your data processing instantly. Read on to understand how to use these formulas in your documents.

SUMIF formula

Description:

Returns the sum of all the numbers in a range based on a condition.

Example:

Let's say you are managing inventory and wish to sum the value of items that have exactly 5 units in stock. 

Below is a sample inventory table.

Formula: =SUMIF(B2:B5, 5, C2:C5)

Output: 8,000 (sum of Chairs and Tables)

Description:

Returns the sum of products by multiplying the input ranges together based on a condition.

Example:

Imagine you are calculating and displaying the total of the quantities in your price list if the quantity is above a certain value, let's say 10.

Below is a sample product pricing table.

Formula: = SUMPRODUCT(if(B2:B4>=10, 1, 0), B2:B4, C2:C4)

Output: 135 (10*6 + 15*5)

Ready to try these out? Check out our user guide to learn how to add these formulas to your documents.

If you have any formula you wish to add to Zoho Writer, please let us know in the comments or at support@zohowriter.com or support@eu.zohowriter.com.