How to Use SUMIFS and COUNTIFS

Рет қаралды 1,207

17 күн бұрын

In this video, learn to master conditional IFs with CountIFS, SumIFS, and AverageIFS in Excel. Explore step-by-step tutorials on using multiple criteria to count, sum, and calculate averages in your spreadsheets. From simple counts to complex calculations, uncover the power of these functions for efficient data analysis. Dive into practical examples, from counting employees to averaging sales based on various criteria. Elevate your Excel skills and unleash the full potential of your data manipulation. Subscribe for more Excel tutorials and unlock the capabilities of your spreadsheets.
🌍 Get unlimited training with Simon Sez IT’s 200+ courses ⏩ www.simonsezit.com/courses/
🚀 Level up your skills with a free 30-day trial to our complete training library of 10,000+ videos ⏩ www.simonsezit.com/ssit-first...
💻 Watch more free popular training tutorials from Simon Sez IT:
🔥Check out our FREE 400+ hour training course playlist here ➡️
• Simon Sez IT Long Trai...
✅ Check out our free video playlist for Excel beginners 👉 • Microsoft Excel Beginn...
✅ Excel 2021 Tutorials for Intermediate Users here 👉 • Excel 2021 Tutorials f...
✅ Microsoft Excel Tips and Tricks 👉 • Microsoft Excel Tips a...
✅ Microsoft Office 2021 and Office 365 Training here 👉 • Microsoft Office 2021 ...
💬Stay in touch!
SimonSezIT.com: www.SimonSezIT.com/
LinkedIn: / simon-sez-it
FaceBook: / simonsezit
🔔 Subscribe to our channel:
kzfaq.info...
If you enjoyed the video, please give a thumbs up 👍🏽 ;-)

Пікірлер: 5

@sanimunir 16 күн бұрын

As always the very first one to watch Deborah Ashby excel video. She has an excellent teaching skill. I love to watch her videos.

@SimonSezIT 14 күн бұрын

Thank you so much for the support and kind words! Glad it was helpful. 🤩

@Exorcistt94 12 күн бұрын

I'm so grateful for your tutorials. You keep them in such a relaxing, but not boring tone! Thanks :) Btw. Your audio quality improved a lot in comparison to previous videos. May I ask what stands behind? New mic or some software?

@SimonSezIT 12 күн бұрын

Thanks for the kind comments 😊 Glad you're enjoying the tutorials and noticing the audio upgrade. It's all about improving the experience for everyone. 🔥

@user-fy4yd9tz4w 16 күн бұрын

Hello. I was wondering if there is a way to match a column of names with a separate column of names to see how many names match? The problem is that in one column, the name might be Mr. Joseph Smith or smith, Joseph Mr. and in the other column his name would read Joseph Smith or Smith, Joseph. I know how to use Conditional Formatting if the names are in the same order (duplicates). Thanks so much. I enjoy your videos so much I subscribed