BUSINESSEDUCATIONNY
  • Home
  • CPU Applications
  • Marketing
    • Marketing Introduction
    • Module 1: Marketing Today & Tomorrow
    • Module 2 Socially Responsive Marketing
    • Module 3: Marketing Begins With Economics
    • Module 4: The Basics Of Marketing
    • Module 5: Marketing Information & Research
    • Module 6: Marketing Starts With Customers
    • Module 7: Competition Is Everywhere
    • Module 8: E-Commerce And Virtual Marketing
    • Module 9: Developing A Marketing Strategy & Marketing Plan
  • Desktop Publishing
  • CFM 25-26
  • CPU APP COLLEGE
    • Part 1 Excel 200
    • Part 2 Excel 201 Advanced
    • Part 3: Microsoft Access 500
    • Part 4: Mr. Kazanjian's Tips & Tricks

MOS Excel 201 Domain 3 Lesson 1


Totals with a Single Criterion


Totals With Multiple Critereon


Average With A Single Criterion


Average With Multiple Criteria


Count With Criteria


Count With Multiple Criteria


Multiple Conditions In Formulas


Partial Condition Match


Opposites Of Matches


10


11


12


13


14

Mr. Kazanjian's Business Class
Hempstead High School
Room A112
​[email protected]

  • Home
  • CPU Applications
  • Marketing
    • Marketing Introduction
    • Module 1: Marketing Today & Tomorrow
    • Module 2 Socially Responsive Marketing
    • Module 3: Marketing Begins With Economics
    • Module 4: The Basics Of Marketing
    • Module 5: Marketing Information & Research
    • Module 6: Marketing Starts With Customers
    • Module 7: Competition Is Everywhere
    • Module 8: E-Commerce And Virtual Marketing
    • Module 9: Developing A Marketing Strategy & Marketing Plan
  • Desktop Publishing
  • CFM 25-26
  • CPU APP COLLEGE
    • Part 1 Excel 200
    • Part 2 Excel 201 Advanced
    • Part 3: Microsoft Access 500
    • Part 4: Mr. Kazanjian's Tips & Tricks