Have you ever struggled with editing your Spreadsheet document while on the go? Well, DocHub has an excellent solution for that! Access this cloud editor from any internet-connected device. It allows users to Omit effect in Spreadsheet files rapidly and whenever needed.
DocHub will surprise you with what it offers. It has powerful capabilities to make any changes you want to your forms. And its interface is so simple-to-use that the entire process from start to finish will take you only a few clicks.
After you complete modifying and sharing, you can save your updated Spreadsheet file on your device or to the cloud as it is or with an Audit Trail that includes all adjustments applied. Also, you can save your paperwork in its initial version or convert it into a multi-use template - accomplish any document management task from anyplace with DocHub. Sign up today!
(light music) - [Instructor] All right if youre using Google Sheets and you have a table of data, like I have right here, and what youre trying to do is use some sort of function in this case, were just using some. And you want to do it on this range of numbers, but it could be other math functions, like lets say, average or count, and it works fine when you can see all the numbers. But if you have some rows hidden, or some rows filtered, it still captures those. So were going to go through two solutions to this, depending on whats going on in your spreadsheet. So right now were doing the sum, so like I talked about, and its summing 22,950. So if I highlight all of these numbers and I look in the lower right-hand corner, 22,950. All right so thats my double-check. But lets say I apply a filter to this. And for some reason, lets just exclude the amount of 554, well click okay. Its not showing in the list anymore, but the sum is still the same. And so technically that sum is