Funzioni nidificate parte 2 (Somma+Cerca.vert+Scegli) - Excel Facile

As mentioned, in this lesson we'll try to answer a simple practical question by using four Excel features in one go: data validation and the Sum, VLOOKUP, and Choose functions, creating a nested formula. To review previous lessons on individual topics, click the links below: Data Validation:    • Menu a tendina e convalida dati - Excel Fa...   VLOOKUP Function:    • Funzione Cerca Verticale (cerca.vert) - Ex...   Sum Function:    • Funzioni Somma e Subtotale - Excel Facile   Select Function:    • Funzione Scegli - Excel Facile   To download the Excel file for this lesson, click here: https://goo.gl/ukx4if ➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖ !!! ATTENTION!!! 📢 Easy Excel is also SOCIAL!! 📢 You can find us on Facebook by clicking here http://on.fb.me/1QMeuvf and on Google+ by clicking here http://bit.ly/1RAiiSY ➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖ For my lessons, I use the Excel version of Office 2016 for Mac. ➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖ 📚📚📚If you want to learn more about Excel, I recommend these books: Excel 2016. Learn to work with spreadsheets: http://amzn.to/2ACjMYH Excel 2016: Formulas and Data Analysis: http://amzn.to/2ABomq8 Microsoft Excel 2016. The Official Guide: http://amzn.to/2CNHeax Working with Microsoft Excel 2016: http://amzn.to/2CPqdh1 Excel 2016. From Beginner to Expert: http://amzn.to/2qAdysz Excel Functions. Practical Guide: http://amzn.to/2CQZQHL Excel Advanced Level for the ECDL Advanced Spreadsheet Certification. Updated to Syllabus 2.0: http://amzn.to/2CKGlQb Effectively Manage Spreadsheets. Excel and Calc. Basic and Intermediate Level: http://amzn.to/2ABI6dl Excel. Formulas and Functions For Dummies: http://amzn.to/2D4Lgca ➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖ ** For more information or to request specific lessons, let me know in the comments. I'll try to accommodate all requests! 😉 ** Thanks for watching! If you enjoyed the video, please give it a 👍🏻 and share it!!!! Tell your friends and colleagues about Excel Easy... they'll thank you!! ✌🏻 If you don't want to miss future lessons, subscribe to the channel: http://bit.ly/ExcelFacile1pxCnjw *NEW LESSON EVERY WEDNESDAY AT 1:30 PM*