ONLYOFFICE Tutorial Series – How to use the SUMIFS function

ONLYOFFICE is a powerful alternative to Microsoft Office and offers a comprehensive suite of similar functionalities. One of the important characteristics of ONLYOFFICE is that it can work very well with Microsoft file formats because ONLYOFFICE was designed from the start, so you have perfect compatibility with Microsoft Office. The ONLYOFFICE counterpart to Microsoft Excel is called Spreadsheet. In this article, I will explain how to use the simple but powerful SUMIFS function to help you sum values ​​based on a combination of conditions.

Content

  1. Introduction
  2. About the SUMIFS function
  3. How to use the SUMIFS function in ONLYOFFICE
  4. Advanced use of the SUMIFS function in ONLYOFFICE
  5. Final words

Introduction

Summing numbers in for example a Revenue column is straightforward to do in any available spreadsheet program. But if your requirements go a bit further, a simple summation will not do. Suppose you want to know your total revenue for a specific year in combination with a specific month in combination with a specific type of product and therefore want to ignore the rest of your data in your analysis, then it becomes a difficult task with standard summations. For these multi-condition situations, the SUMIFS function is perfect. So let’s investigate how this function can be used for your purposes.

About the SUMIFS function

As mentioned above, the SUMIFS function helps to sum numbers under specific conditions, while everything that does not match these conditions is excluded from the summation. The SUMIFS function is part of the math and trigonometry functions. The SUMIFS function has the below syntax:

=SUMIFS(Sum-range,Criteria_range1,Criteria1,Criteria_range2,Criteria2,etc)

In this function, we have the following components:

Because this article on ONLYOFFICE has a further reach than Linux only, you can read the remainder of my article “ONLYOFFICE Tutorial Series – How to use the SUMIFS function” on my other website, RealAppUser.com.

About John Been

Hi there! My name is John Been. At the moment I work as a senior solution engineer for a large financial institution, but in my free time, I am the owner of RealAppUser.com, RealLinuxUser.com, and author of my first book "Linux for the rest of us". I have a broad insight and user experience in everything related to information technology and I believe I can communicate about it with some fun and knowledge and skills.

View all posts by John Been →