Milestone -3

Chapter -8 : Conditional functions

Learn to perform calculations based on some conditions using advanced formulas such as SUMIF, COUNTIF, and more. Automate boring work with Excel table.

COUNTIF function

Load content from vimeo.com?
Loading external content may reveal information to 3rd parties. Learn more
Allow

COUNTIFS functions

Load content from vimeo.com?
Loading external content may reveal information to 3rd parties. Learn more
Allow

SUMIF and SUMIFS functions

AVERAGEIF and MAXIFS functions

Creating Excel Tables

Automation Using Excel Tables


Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.