Excel Forum
Similar Content
Simple Excel Function to Combine Values in All Versions of Excel - UDF
: Excel function that combines values from multiple cells or inputs using a delimiter - work...
Simple Excel Function to Combine Text with a Separator
Tutorial: Excel function that makes combining text very easy. This function is simpler and better th...
Insert Check Mark in Excel - 3 Ways - Incl. VBA and UDF
Tutorial: This tutorial goes beyond other simple check-mark tutorials. Here, I'll show you 3 methods...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



Office 2010 Class #24: Excel Functions COUNTIF & SUMIF Count and Add with one Condition (Criteria)


The Excel 2010 Basics Series shows a systematic description of what Excel can do from beginning to end.
Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/busn216.htm
Topics Covered In Video:
1. Learn how to use the Excel Functions COUNTIF & SUMIF Count and Add with one Condition (Criteria).
2. Create Names From Selection keyboard = Ctrl + Shift + F
3. Use Defined Names in formulas
4. Learn about Name Manager
5. Learn about comparative operators when creating criteria for COUNTIF and SUMIF functions.





Got a Question? Ask it Here in the Forum.