How to Omit Hidden or Filtered out Values in Sum [Google Doc Spreadsheet]
Google Doc Spreadsheet has lots of similar Excel functions to fulfill users data entry needs. Here is one useful tips for Google Doc Spreadsheet users. If you are familiar with Microsoft Excel you may have already known to this. Let us see how to exclude values in hidden rows or filtered out rows in a total in Google Doc Spreadsheet.
Instead of using sum() function, here you have to use subtotal() function. To make a total or “sum” using subtotal function, you have to use the sum function number, i.e., 109 with in the subtotal. It’s very simple. The below example is enough to understand this.
See the above animated GIF screenshot. In the above, row number 3 is hidden. While the sum function adds the value in the hidden row, subtotal function omits the same. Same will happen if you apply subtotal function in filtered table. Hope you enjoy this quick Google Doc Spreadsheet tip.
About Article Author
Learn how to create a chart in Google Doc Spreadsheet. It’s so simple that any one without any prior knowledge
Earlier we have posted a complete tutorial about creating line chart in Google Doc Spreadsheet. Now in this post we
A pro MS Excel user may find some difficulty in getting familiar with Google Spreadsheet. There are plenty of shortcut
In this tutorial I will explain you how to use Data Validation on Google Doc Spreadsheet. It is important to
It is not necessary to depend PowerPoint to make ‘powerful’ presentations. You can use Google Drive Presentation easily to make
All spreadsheet users proud to know the use of Vlookup and Hlookup, if they use spreadsheet for serious data entry.