Need to easily set formula in Rights Agreement? We've got you covered! With DocHub, you can do just what you need without downloading and installing any application. Use our tools on your mobile phone, PC, or web browser to modify Rights Agreement anytime and anywhere. Our powerful platform provides basic and advanced editing, annotating, and safety measures suitable for individuals and small companies. Plus, we provide detailed tutorials and instructions that help you learn its capabilities swiftly. Here's one of them!
We offer a range of security options to protect your sensitive information while you set formula in Rights Agreement, so you can feel comfortable of your work’s privacy. Get your documents edited, signed, and sent with a professional, industry-compliant platform. Enjoy the comfort of getting the job done quickly with DocHub!
(playful cartoon music) Lets take a look at Excels 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 its 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. Its 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. Its a condition, right? The formula I would be using is the SUMIF or the SUMIFS function, but I
