Editing OSHEET is fast and simple using DocHub. Skip downloading software to your computer and make alterations with our drag and drop document editor in just a few fast steps. DocHub is more than just a PDF editor. Users praise it for its ease of use and powerful features that you can use on desktop and mobile devices. You can annotate documents, create fillable forms, use eSignatures, and send documents for completion to other people. All of this, combined with a competing cost, makes DocHub the perfect decision to italics identification in OSHEET files effortlessly.
Make your next tasks even easier by converting your documents into reusable templates. Don't worry about the protection of your information, as we securely store them in the DocHub cloud.
(playful cartoon music) Letamp;#39;s take a look at Excelamp;#39;s INDIRECT function. Now INDIRECT is a bit of a strange function and it takes a little bit of time to get the hang of. But itamp;#39;s very useful because it can easily handle cases where you have different ranges that you need to feed other formulas. Let me give you an example. Here I want to get the total revenue depending on the year that I select. Just have two years in this example of the divisions that I have listed here. Now the tricky part is, my data is not set up in one single data table and one single tab. Itamp;#39;s actually split between two different tabs. So this tab is for 2016 data only and this tab is for 2017 data only. You can see I formatted my table as an official Excel table and this one is called datapy for previous year and the other one is called datacurrent. So what I want to do is to get the full revenue depending on this. Itamp;#39;s a condition, right? The formula I would be using is