GOOGLE FOGLI tutorial 22: Funzioni condizionali avanzate (criteri multipli)

☕ Support me with a free donation ➜ https://www.paypal.me/FrancescaMartorana 📗 Request the material created specifically for this course, writing to me through the contact form on my website ➜ https://www.FantasticaMenteING.com​ 🌍 ⭐ Google Sheets #googlesheets - Video course in Italian 📊 Tutorial 22: Advanced conditional functions in Google sheets COUNTIFS ( COUNTIFS ), SUMIFS ( SUMIFS ), AVERAGEIFS ( AVERAGEIFS )⭐ In this video we learn how to use COUNTIFS, SUMIFS and AVERAGEIFS to perform counts, sums and averages based on multiple criteria in Google Sheets! These functions are essential for filtering and analyzing data precisely and quickly, allowing you to count, sum, and calculate averages based on multiple criteria at once. 🔍 Here's what you'll learn: 🟢 COUNTIFS function: Counts cells that meet multiple conditions ▶ Syntax: =COUNTIFS(range1; criteria1; [range2; criteria2; ...]) 🟢 SUMIFS function: Adds only the values ​​that meet multiple conditions ▶ Syntax: =SUMIFS(sum_range; range1; criteria1; [range2; criteria2; ...]) 🟢 AVERAGEIFS function: Calculates the average of values ​​filtered by multiple criteria ▶ Syntax: =AVERAGEIFS(average_range; range1; criteria1; [range2; criteria2; ...]) 🎯 Practical example: In the video I show a real case in which we analyze the data of a tech company to: ✅ Count how many employees meet certain requirements ✅ Calculate the total salaries of employees with specific characteristics ✅ Find the average salaries by filtering on department, years of experience and evaluation Useful links: ⮕ COUNTIFS – SUMIFS – AVERAGEIFS functions in Excel:    • EXCEL tutorial 7C1: CONTA.PIÙ.SE – SOMMA.P...   ⮕ Conditional functions COUNTIF, SUMIF, AVERAGEIF in Google Sheets:    • GOOGLE FOGLI tutorial 21: Funzioni condizi...   👍 Follow me on Facebook ➜   / fantasticamenteing   💙 Follow me on Instagram ➜   / fantasticamenteing   ♪ Follow me on TikTok ➜   / fantasticamenteing   📱Subscribe to the WhatsApp channel ➜ https://whatsapp.com/channel/0029VaKN... 🔔 To be updated on the next uploads, subscribe to the channel and activate notifications by clicking on the bell. Thanks for following me! 💼 Eng. Francesca Martorana #google #sheets #function