Ch 13: Functions with Conditional Logic in Excel

About This Chapter

Learn all about using functions with conditional logic in Excel. This handy collection of video lessons walks you through three of these essential Excel functions.

Functions with Conditional Logic in Excel: Chapter Summary

If you want to add cells, look at the average of the cells or count the number of cells within a specific Excel range, this set of video lessons might be for you. Our experts will show you all the steps for success through these instructional videos. Each lesson has a short quiz to give you feedback on your progress. Watch each video as many times as you need, or read the accompanying transcripts, until you've got these functions down pat.

Lessons include the following:

  • Using the SUMIF Excel function
  • Putting the AVERAGEIF function into play
  • Using the COUNTIF function

(Note: All demonstrations in this chapter will be using Microsoft Excel 2013. Certain features, tools, or displays may be different in other versions.)

Excel is a trademark of the Microsoft Corporation, which is not affiliated with

Chapter Practice Exam
Test your knowledge of this chapter with a 30 question practice chapter exam.
Not Taken
Practice Final Exam
Test your knowledge of the entire course with a 50 question practice final exam.
Not Taken

Earning College Credit

Did you know… We have over 200 college courses that prepare you to earn credit by exam that is accepted by over 1,500 colleges and universities. You can test out of the first two years of college and save thousands off your degree. Anyone can earn credit-by-exam regardless of age or education level.

To learn more, visit our Earning Credit Page

Transferring credit to the school of your choice

Not sure what college you want to attend yet? has thousands of articles about every imaginable degree, area of study and career path that can help you find the school that's right for you.