You know you are using the right file editor when such a basic task as Go over dropdown lease does not take more time than it should. Editing files is now a part of a lot of working operations in various professional fields, which explains why accessibility and simplicity are crucial for editing resources. If you find yourself studying manuals or searching for tips on how to Go over dropdown lease, you might want to find a more easy-to-use solution to save time on theoretical learning. And this is where DocHub shines. No training is required. Simply open the editor, which will guide you through its principal functions and features.
A workflow gets smoother with DocHub. Make use of this instrument to complete the paperwork you need in short time and get your efficiency to a higher level!
[Music] oh and welcome to the excel caves today were going to talk about using the some is formula with a drop down selection list and before I begin I just want to go ahead and show you the finished product just so you can see what that looks like in this example we have list of monthly sales by region by quarter and you can see here we want to create a drop-down list that summarizes the quarter where we can just select and you can see the sales revenue it just sums does the sum if based on your selection of the quarter from the drop-down list so lets get started here now the first thing you want to do is create a drop-down list and before you do that its a good idea to just have your list in a range of cells somewhere because when you create it all you have to do is just select this range and youll have your list right away so to do that youre gonna go up to your ribbon up top and go to data and then theres gonna be an option towards the right that says data validation youll