Excel Forum
Similar Content
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...
How to Find and Understand Excel Functions
Tutorial: In this tutorial I am going to show you how to find and understand new Excel Functions. If...
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...



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.