Quantcast

I4C

SUMIF and COUNTIF Basics

SUMIF and COUNTIF Basics in Excel

SUMIF and COUNTIF let Excel total or count only the data that matches a condition. These functions are helpful when you need to summarize a list without filtering it manually.

Previous lesson: IF Function Basics

Next step: Continue to Percentages in Excel.

What would you like to do next?

 

 

Internet4classrooms is a collaborative effort by Susan Brooks and Bill Byles.
 

  

Use of this Web site constitutes acceptance of our Terms of Service and Privacy Policy. 

39 desktop not tablet not iPad device-width